What is the difference between inner join, left join, right join and full join? - Quora

INNER join (the most common) produces a row only when the join condition holds; Outer join (LEFT and RIGHT) always produce a row, populated from the left (or right) table, with NULLs in those parts of the row where the join condition does not hold; FULL J

www.quora.com