Hello,
I have made a query from 3 tables.
It has Date of sale, Invoice ID, Customer ID, Type of Sale and Sum of Total columns.
sum of total is arrive from Group By sum method.
I want separate Cash column which will have Cash Total and separate Credit column which will have Credit Total.
From this
Date of sale InvoiceID CustomerID TypeofSale SumofTotal
30/04/2020 1 1 Cash 0.00
30/04/2020 2 7 Credit 300.00
Like this -
Date of sale InvoiceID CustomerID Cash Credit
30/04/2020 1 1 300.00 0.00
30/04/2020 2 7 0.00 300.00
How can i achieve this ?
Thanks.