mysql多表左外链接的代码示例

select a.run_id as 流水号,date_format(a.begin_time,'%Y-%m-%d') as 发文日期,a.data_m361 as 份数,b.data_m356 as 发往单位,a.data_m351 as 拟稿单位,b.data_m355  as 文件标题,  d.sign_content AS 签发意见, d.sign_user 签发人,  d.sign_time 签发时间
FROM bpm_data_21 a left join bpm_data_21_child b on a.run_id=b.run_id 
left join bpm_run c on a.run_id=c.RUN_ID 
LEFT JOIN bpm_form_countersign d on a.run_id=d.run_id and d.flow_prcs=8
WHERE c.DEL_FLAG=0 and b.data_m355!=''