WAY Academy interview question

Do you know LEFT JOIN in SQL query?

Interview Answer

Anonymous

6 Jan 2016

A left join will join a row and the joined columns will be null if there is no match to the ON criteria. This is in contrast to an inner join which will omit a row entirely when the ON criteria isn't met.