我有2个表,一个表是公司列表,另一个是产品列表。产品在“ company_id”列中链接到公司
为了更好地理解,这是我想要做的:
SELECT * FROM Products WHERE company_id = (Company.id where name = Google)
编写此语句的正确方法是什么?
将其写为子选择
SELECT * FROM Products WHERE company_id =(SELECT id FROM companies WHERE name = 'Google' limit 1)
或者使用in()运算符进行子选择
SELECT * FROM Products WHERE company_id in (SELECT id FROM companies WHERE name = 'Google')
或将其写为联接
SELECT p.*
FROM Products p
inner join companies c on p.company_id=c.id
WHERE c.name='Google'
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句