[thelist] Joining tables... in MySQL

Mark Groen evolt at markgroen.com
Wed Apr 4 09:28:15 CDT 2007


On Wednesday 04 April 2007 07:10, Sarah Adams wrote:
> >.........
> I think what you need is "LEFT JOIN" instead of "RIGHT JOIN".

From what is described as the output needed, think you are correct Sarah. 
Here's an explanation for Tris about each type of join, and the results to 
expect, no Rudy required:

<http://www.wellho.net/mouth/158_MySQL-LEFT-JOIN-and-RIGHT-JOIN-INNER-JOIN-and-OUTER-JOIN.html>
-- 
cheers,

        mark



More information about the thelist mailing list