Do you know LEFT JOIN in SQL query?
Anonymous
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.
Check out your Company Bowl for anonymous work chats.