左链接问题，求大神指教

要实现的效果，如图。

数据库是ms sql

 select m.bill_dt,hr.cname,m.deptid,m.title
from p_form0000000321_m m
left join hr_epm_main hr on hr.cno=m.fillpsn

select a.bill_dt,b.cname,a.deptid,a.title
from p_form0000000321_m a left join hr_epm_main b a.fillpsnon =b.cno

select p_form0000000321_m.bill_dt,hr_epm_main.cname,p_form0000000321_m.deptid,p_form0000000321_m.title
from p_form0000000321_m left outer join hr_epm_main on p_form0000000321_m.fillpsn=hr_epm_main.cno