Quick Links : left outer join
 
left outer join
See outer join.