select group_id from fs_server_location where room_id in {select room_id from fs_server where server_id=484 } 这条语句是错的 请问下mysql里面有木有可以代替这个操作的 我不想把room_id查出来的东西再拼接成字符串,太麻烦了
select group_id from fs_server_location where room_id in (select room_id from fs_server where server_id=484 ) ;
select group_id from fs_server_location where room_id in (select room_id from fs_server where server_id=484 )或者 select A.group_id from fs_server_location A, fs_server B where A.room_id = B.room_id
select A.group_id from fs_server_location A, fs_server B where A.room_id = B.room_id and B.id=484
select A.group_id from fs_server_location A inner join fs_server B on A.room_id = B.room_id
select group_id from fs_server_location where room_id in (select room_id from fs_server where server_id=484 )
select group_id from fs_server_location where room_id in (select room_id from fs_server where server_id=484 )
select A.group_id
from fs_server_location A, fs_server B
where A.room_id = B.room_id
from fs_server_location A, fs_server B
where A.room_id = B.room_id and B.id=484
from fs_server_location A inner join fs_server B on A.room_id = B.room_id