Query Help 1

[TheConeHead]

I need a query that will return all records that:

NOT field1 = 'a'

AND

field2 = '1' OR field2 = '2' OR field2 = '3'

AND (here is the problem)

if field1 = 'b' I wonly want the records where

field2 = '1' OR field2 = '2'

 

[Katy44]

select ...
where (field1 = 'b' and (field2 = '1' OR field2 = '2'))
or(field1 <> 'b' and (field2 = '1' OR field2 = '2' OR field2 = '3'))
..I think!

 

[TheConeHead]

hmmm... doesn't seem to be doing it...

 

[SQLBill]

Katy44,

Your query would also return where Field1 = 'a'.

TCH,

Try changing the last part of Katy44's query to this:

or(field1 NOT IN ('a', 'b')
and (field2 = '1' OR field2 = '2' OR field2 = '3'))

-SQLBill

Posting advice: FAQ481-4875