我需要从具有两个城市ID(假设7333和10906)的表中获取所有公司ID,但是ID不能像我那样工作。
这是我的桌子:
这是我的代码
SELECT `company_id` as id
FROM `logistics_companies_destinations`
WHERE `city_id`= 7333 and `city_id` = 10906
您还可以使用INNER JOIN
表本身来解决此问题,将其连接到表上company_id
并要求同时显示两个city_id:
SELECT
`lcd1`.`company_id` AS id
FROM `logistics_companies_destinations` AS lcd1
INNER JOIN `logistics_companies_destinations` AS lcd2
WHERE `lcd1`.`city_id`= 7333 AND `lcd2`.`city_id` = 10906
抱歉,我通常也不会像这样愚蠢地缩写表名,但是并没有提供更好的别名;)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句