Hiya, quick question on how to do IF... Then type queries.

Variables are REF_NO, LINE_OBJECTS and LINE_ACTION. There are 2 types of data that I want returned:
a) where REF_NO<>0 and LINE_OBJECT in (11, 27) and LINE_ACTION =603
and
b)where REF_NO=0 and LINE_OBJECT=25 and LINE_ACTION=650

What I want to avoid is to return rows where it only has LINE_ACTION= 11 and 25 against it. I want either 11, 27 and 25 or just 11 and 27.

Probelm is, I have no idea how to go about putting such conditions in my SQL (which is simple SELECT statement)

Any help will be welcome!

Fiona