esn studio

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

Referral text link:

This entry was posted on Friday, March 2nd, 2007 at 11:46 am and is filed under Snippets, PHP, Random. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.