日期:2014-05-16 浏览次数:20720 次
select t.*,t.id in (SELECT a.id FROM depart a LEFT JOIN enterworker_depart b ON a.id=b.departid left JOIN enterworker c ON b.workerid=c.id where c.id=22) FROM depart t