JOin problem

[willoworks]

I have been messing with this simple problem too long.
This code:

$query = mysql_query("SELECT * FROM boats, dealers
INNER JOIN dealers ON boats.code = dealers.code

WHERE make LIKE '%$make%' AND size LIKE '%$size%'");

always fails when I add the join in. The two tables are boats and dealers, both have the field code which is the dealer code and the field I am trying to join on. I only want to pull the dealer name out of the database for each listing, it shouldn't be that hard~

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/boatdi2/public_html/listings/search2.php on line 55

[swampBoogie]

 $query = mysql_query("SELECT * FROM boats
INNER JOIN dealers ON boats.code = dealers.code
WHERE make LIKE '%$make%' AND size LIKE '%$size%'") 
or die(mysql_error());

[willoworks]

Swampboogie,
Don't know WHY it worked, but it did
Thanks a million.