我不熟悉数据库.所以,我得到了两个表product
和supplier
,我需要做一个查询,打印出售出的产品以及一些供应商信息.
product
表:
Product_ID | Product_Name | Quantity | Supplier_ID |
---|---|---|---|
1 | water | 0 | 11 |
2 | Milk | 26 | 12 |
3 | eggs | 8 | 12 |
4 | 5L water | 19 | 11 |
5 | water gallon | 0 | 11 |
supplier
表:
Supplier_ID | Supplier_Name | Supplier_Phone |
---|---|---|
11 | Pure life | 55555555 |
22 | Dairy | 77777777 |
33 | Nivea | 66666666 |
我目前的工作:
SELECT product.Product_ID, 'product.Product_Name', product.Quantity,
'supplier.Supplier_Name', supplier.Supplier_Phone
FROM product, supplier
INNER JOIN supplier S ON supplier.Supplier_ID = product.Supplier_ID
WHERE (Quantity = 0)
GROUP BY 'product.Product_Name';
输出:
Error Code: 1054. Unknown column 'product.Supplier_ID' in 'on clause'
所需的输出:
Product_Name | Quantity | Supplier_Name | Supplier_Phone |
---|---|---|---|
water | 0 | Pure life | 55555555 |
water gallon | 0 | Pure life | 55555555 |