Web Development Blog

Use LEFT JOIN when you want to return all rows from left table regardless of whether they have any associated rows on right table.

Use RIGHT JOIN when you want to return all rows from right table regardless of whether they have any associated rows on left table.

SELECT
  users.`firstname`,
  pets.`nickname`
FROM `users`
LEFT JOIN `pets`
ON users.`id` = pets.`user`";

The above query will return all rows in users table regardless of whether they have any pets associated with them or not.

Technorati Tags: mysql, sql, join, left join, right join

Found this article useful? Share it with your friends: