A LEFT join gives you one record for each record in the table on the left of the join condition, RIGHT gives you one for each record in the table on the right side.

An INNER join gives you only records that are in both tables.

Just to cover all bases, a FULL join gives you all the records from both tables.

>What is the difference between a left join, right join and an inner join in a quick summary?