Thread: JOIN query
View Single Post
Old 11-26-2010, 12:42 PM   #4 (permalink)
captainmerton
The Acquainted
 
captainmerton's Avatar
 
Join Date: May 2009
Posts: 178
Thanks: 9
captainmerton is on a distinguished road
Default

Schroder thanks your solution solved it. In my head i knew what i wanted to do but had the following:

OR imageid = NULL

which didnt bring back the rows where the image columns were null. Changed that to:

OR imageid IS NULL

and it worked.

Cheers.
captainmerton is offline  
Reply With Quote