SELECT product.ID, product.ProductName, product.ISBN, SUM(salesreport.QTY) as
Total_Quantity FROM salesreport, product WHERE product.ID = salesreport.ID GROUP BY
salesreport.ID ORDER BY Total_Quantity DESC;
On Nov 10, 2010, at 3:53 PM, HaidarPesebe wrote:
> 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.
