LEFT JOIN Developer T-Shirt

Slash Star Verified independent store

→

LEFT JOIN returns every row from the left table, matched with the right where a match exists and filled with NULL where it doesn't. The distinction from INNER JOIN is the whole poi nt: it keeps the rows that didn't match instead of silently dropping them. Reach for it when absence is data too. Show more