please help us look for the data select from two tables with the following details: Primary table: product ID | ProductName | ISBN | --------------------------- 1 | Product A | 123 | 2 | Product B | 456 | 3 | product C | 444 | ---------------------------
second table: salesreport IDS | ID | CITY | QTY | ------------------------ 1 | 1 | New York | 3 | 2 | 1 | Alabama | 5 | 3 | 1 | London | 1 | 4 | 1 | Jakarta | 5 | 5 | 2 | New York | 8 | 6 | 2 | Alabama | 4 | 7 | 2 | London | 9 | 8 | 2 | Jakarta | 3 | -------------------------- ID in table product same with ID table salesreport How we will show SALES REPORT product is sold only at the table salesreport SUM qty to the top sold and unsold product C will not be displayed. The result will be like this: -------------------------------- No. Product Name ISBN QTY -------------------------------- 1. product B 456 24 2. product A 123 14 -------------------------------- I'm using PHP. Thanks a lot for information.