mysql中有关查询in的用法
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 inner join fs_server B on A.room_id = B.room_id