we've tried to use as your dialing purposes, but still can not.
This structure
SELECT product.product_id, product.isbn, product.name, product.author,
product.harga, product.discount, sum(sales_report.qty) as totalqty FROM " .
$prefix . "_sales_report, " . $prefix . "_product WHERE product.product_id =
sales_report.bid GROUP BY sales_report.bid ORDER BY totalqty DESC
Display error on the screen like this:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in E:\xampp\htdocs\test\inc\sqllayer.php on line 271
Unknown column 'product.product_id' in 'field list'
Note: product_id (product) = bid (sales_report)
haidarpesebe
----- Original Message -----
From: "Aveek Misra" <ave...@yahoo-inc.com>
To: "HaidarPesebe" <haidarpes...@gmail.com>
Cc: "MySQL Lists" <mysql@lists.mysql.com>
Sent: Wednesday, November 10, 2010 5:38 PM
Subject: Re: select data from two tables and SUM qty of the same ID
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.
__________ Information from ESET Smart Security, version of virus signature
database 5608 (20101110) __________
The message was checked by ESET Smart Security.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org