is there a trick to LEFT JOINS

This is driving me batty

I have executed my first LEFT JOIN and it works awesome

$result = mysql_query("SELECT a.carat, a.color, a.clarity, a.shape  FROM diamonds AS a 
INNER JOIN clarity AS b ON a.clarity = b.clarity

ORDER BY a.carat LIMIT 1,10 ");

Code (markup):

However when I go and add another INNER JOIN I get an error

I even went as far to check to make sure the field types matched etc which I don't think that matters.

When I add

INNER JOIN shape AS c ON a.shape = c.shape

Code (markup):

I get an error

So I trouble shot it and just added the shape JOIN in and still error

thing is that the clarity table and the shape table are very similar and I do not see why the shape wouldn't work.

 

nvm thank you

echo mysql_error($link);

we live and we learn

 

http://en.wikipedia.org/wiki/Join_(SQL)
is a good start..