Using AND and OR and XOR in WHERE statement

passagewds

I have the following

$gt_group = mysql_query("SELECT Breeders.*, Breeds.* FROM Breeders, Breeds, Xtable WHERE Xtable.BR_Group='1' AND Xtable.BR_Id=Breeds.BR_Id AND Xtable.MB_Id=Breeders.MB_Id ORDER BY Breeds.breed_Name");

It works fine except that it doesn't select the breeds that don't have a breeder assigned to them. Is there a way to modify the WHERE clause to bring all the breeds in and not just the ones that have breeders associated.

THANKS

tekky

try adding an OR breeder.MB_id = NULL maybe?

passagewds

Thanks for the idea but it didn't work.

tekky

Originally posted by tekky
try adding an OR breeder.MB_id = NULL maybe?

uhm duh, you might have to use column_name IS NULL (forget if = NULL will work or not)

passagewds

Still Didn't work but found a work around for it. I put in a default breeder (the association) in for each breed so each breed has at least one breeder.