左连接

 

 

 

 

 

 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