where statement 1

[simanek]

I'm writing a statement where I want to select multiple conditions in the 'where' part of the statement. For example: select &quot;id&quot;, &quot;state&quot;, &quot;problem&quot;, &quot;solution&quot;, &quot;date&quot;, from &quot;reports&quot; where id<50 and id>20 state=critical date>1/1/01 and date<6/1/01

Everything after the 'where' i'm not sure how to do. Any help would be appreciated. Is it even possible? Thanks.

Mike

 

[Cagliostro]

where x = something and y = otherthing or z = 'somestring' or a in(a set of values)... John Fill

ivfmd@mail.md

 

[simanek]

so just separate each condition by a logical operator?

 

[Cagliostro]

yes John Fill

ivfmd@mail.md