我有以下MySQL语句,其中包含几个select语句,其中一个对另一个select返回的所有结果进行选择。只是想知道是否可以将它组合成一个整体。例如。就像三重联接。
select networks.name as network_name, installations.name as installation_name
from network_installations
join installations on installations.id = network_installations.installation_id
join networks on networks.id = network_installations.network_id
where network_installations.network_id in (
select network_installations.network_id
from network_installations
where network_installations.installation_id = 1
);
笔记。我已经完成了sql查询,但这是我第一次使用sql join。
对表network_installations使用别名:
select networks.name as network_name, installations.name as installation_name
from network_installations ni1
join installations on installations.id = ni1.installation_id
join networks on networks.id = ni1.network_id
join network_installations ni2 on ni2.network_id = ni1.network_id
where ni2.installation_id = 1
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句