Model N Interview Question

Please describe a left join in SQL.