Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT p.pcode,p.productName,i.pcode,SUM(i.cash) AS cash_x,SUM(i.credit) AS credit_x FROM (SELECT p.pcode,p.productName,CASE WHEN item_for="cs" THEN soldPrice ELSE 0 END AS cash, CASE WHEN item_for ="cd" THEN soldPrice ELSE 0 END AS credit FROM tbl_products p INNER JOIN tbl_sold_items i ON p.pcode = i.pcode) AS sales GROUP BY i.pcode
Add Comment
Please, Sign In to add comment