What is the proper way to write this query

[aeroswat]

I need a query that uses an AND and multiple OR's. Basically the results have to have be unfilled orders that are either audio orders, electronic text orders, or large print orders. So the logic would be like this but i'm not sure if this is the correct way to write it.

 

SELECT * FROM table WHERE filled=0 and (type='audio' OR type='electronic' OR type='large print')

[agrant]

I would write the code like this...

 

SELECT col1, col2 FROM table WHERE filled=0 and type in ('audio','electronic','large print')

 

select on a certain columns instead of using *, this will speed up the query.

and switch the "ORs" to an "in" statement.

 

hope that helps,

Aaron