OR WHERE?compound query i guess...

[drewbie]

hey there!how do i type this query correctly?there's basically two different "queries" i guess u'd call them, but obviously its one query, im not sure what to call the two, anyone know? well anyways think of the "OR" as a seperator, like saying "OR WHERE", but mysql didnt like "OR WHERE" 🙂

SELECT * FROM login, contact_info, categories WHERE login.ID = contact_info.ID = categories.ID && contact_info.Zip='91737
' && categories.C32='1' OR login.ID = contact_info.ID = categories.ID && contact_info.Zip='91729' && categories.C32='1';

Thanks for any help!I'm still pretty basic on mysql queries....

[Lars_Berg]

SELECT * 
  FROM login, 
       contact_info, 
       categories 
 WHERE login.ID = contact_info.ID 
   and contact_info.ID = categories.ID 
   and contact_info.Zip in ('91737','91729')
   and categories.C32='1' 

[notionlogic]

Since it's only the "zip" part that differs, shouldn't that be:

SELECT * FROM login, contact_info, categories 
WHERE  login.ID = contact_info.ID 
AND login.ID = categories.ID 
AND categories.C32 = '1'
AND
( contact_info.Zip = '91737'
OR
 contact_info.Zip = '91729' )
 

at least that's how I would do it...

[drewbie]

Thanks guys, they both work like a charm! Keepin the scene alive!!!