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