List:General Discussion« Previous MessageNext Message »
From:Biz-comm Date:January 2 2012 3:33pm
Subject:Beginner question
View as plain text  
Thanks for any assistance.

Web page  that needs a sort of all records with a specific state, set to "show", and if it
exists in one of 4 categories.

Using this:

FROM listings
WHERE listing_state = 'DC' 
AND listings.listing_show ='y'  
AND  listings.cat1 = 23  OR listings.cat2 = 23 OR listings.cat3 = 23 

Gives up 2 records in the state of DC, set to show, and are listed in cat1.

However, it also gives up 2 records in the state of VA, set to show, but are listed in
cat2 (not in 1).

Any assistance most appreciated.


Patrice Olivier-Wilson

Beginner questionBiz-comm2 Jan
  • Re: Beginner questionReindl Harald2 Jan
  • Re: Beginner questionMike OK2 Jan
    • Re: Beginner questionBiz-comm2 Jan