SELECT d.id,d.depid,di.depname
FROM dep as d
LEFT JOIN dep_info as di ON d.depid=di.id
SELECT * FROM work_daily_department_rule
left join system_social_user_bind ssub on ssu.id = ssub.social_user_id
where
ssu.deleted = 0
and ssub.deleted = 0
标签：di,deleted,ssub,id,depid,连接,SELECT From： https://www.cnblogs.com/dxy1493449304/p/17190730.html