MySQL的嵌套子查询
SELECT sa.area_name,sst.stay_des,sp.*
FROM
(SELECT sm.*
FROMsys_monitoring sm
JOIN sys_orders so ON sm.monitoring_id = so.monitoring_id
JOIN sys_dept sd ON sd.dept_id = so.dept_id
WHERE sd.dept_id = 1) a
JOIN sys_preset sp ON sp.channel = a.channel
JOIN sys_stay_t sst ON sp.stay_id = sst.stay_id
JOIN sys_preset_scene sps ON sps.scene_id = sp.scene_id
JOIN sys_area sa ON sa.area_id = a.area_id
WHERE sps.scene_name = '河流'