Ally Financial Interview Question

Describe your experience with SQL/SAS. Can you explain what a left join is?