11.4工作总结（sql语句）

1 . sql语句

SELECT * FROM device d where d.devid  in(SELECT orgid FROM project WHERE projectid = 9)

select d.devid,d.devname,d.prodname,d.prodmodel,d.gateway from device d left join project p on d.devid = p.orgid WHERE projectid = 9

SELECT * FROM device de where de.devid  in(select d.devid from project_device d left join project p on d.projectid = p.projectid WHERE p.projectid = 88)