日期: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