我试图在sql中运行此代码.但是给了我一个缺少关键字的错误

Question

SELECT order_id,   ordered_quantity,  product_description , standard_price FROM m_product 
JOIN m_order_line 
WHERE product_description = 'End Table' OR product_description = 'Coffee Table' OR product_description   = 'Dining Table'
ORDER BY product_description;

Answer 1

必须定义在哪个公共列上执行连接使用并给身亡到你的表

allies:- m1 ane m2-m1.yourcolumn或m2.yourcolumn

SELECT 
order_id,
ordered_quantity,
product_description,
standard_price 
FROM m_product as m1
JOIN m_order_line as m2 on m1.columnname = m2.columnname
WHERE product_description = 'End Table' OR product_description = 'Coffee Table' OR product_description   = 'Dining Table'
ORDER BY product_description;