Mysql – How to retrieve data from 2 different where?
I don't know how to word the title properly, anyway what I mean is: For example I have this 'transaction' table SELECT ITEM_ID, SUM(QUANTITY) AS IN WHERE TYPE = IN GROUP BY ITEM_ID - SELECT ITEM_ID, SUM(QUANTITY) AS OUT WHERE…