这个查询有什么问题?
SELECT ps_stock_available.quantity
FROM ps_stock_available
INNER JOIN ps_product_attribute ON ps_product_attribute.id_product ON ps_stock_available.id_product
WHERE ps_product_attribute.reference =100102
我想你打算:
SELECT sa.quantity
FROM ps_stock_available sa INNER JOIN
ps_product_attribute pa
ON sa.id_product = pa.id_product
WHERE pa.reference = 100102;
注:
- 使用表别名。它们使查询更易于编写和读取
ON
子句包含一个布尔表达式- 单个
JOIN
具有单个ON
子句