经获取到这个dorm_id，然后怎么关联去查这三个表啊，一直写不出来，有大神可以写给我吗？
我假设你要取三个表的全部字段 select a.*,b.*,c.* from ims_sibox as a left join ims_sgoods_dorm as b on a.id = b.dorm_id
select a.*,b.*,c.* from ims_sibox as a left join ims_sgoods_dorm as b on a.id = b.dorm_id
我假设你要取三个表的全部字段
select a.*,b.*,c.* from ims_sibox as a left join ims_sgoods_dorm as b on a.id = b.dorm_id