Select a.s aleno as single, a.a ccdate as accounting, aleem walji areqty as quantity, b.s aleprice as price, a.net price as firm and e.p aytype as payment
The from u_sale_c as a left join u_sale_m as c on a.s aleno c.s. aleno=left join u_ware_q as b on aleem walji areid=b.w areid left join u_sale_pay as e on a.s aleno=e.s aleno
Where a.a ccdate='2018-08-05' and a.s aleno in (180805100100165)
The order by a.s aleno, a.a ccdate

The current query the same number have two payment information, how to rule out a payment to the other the same number of different also ruled out the mode of payment

CodePudding user response:

did not understand, can you again

CodePudding user response:

Columns such as [I] number 1 sales of goods corresponding to the two payment. A, B queries when we exclude payment automatically from A sales number 1 corresponding other lending

CodePudding user response:

Built the predicative clause (irrelevant columns don't write), the insert statement, and issue to the desired result,