Select Statement, Where clause help - need to select active projects & closed projects from this year

Question

I have a very simple question (I think):
I know how to do this using two queries:

Select * from TABLE
WHERE PROJECT_STATUS LIKE 'ACTIVE';

and...

Select * from TABLE
WHERE PROJECT_STATUS LIKE 'CLOSED' AND COMPLETION-DATE > '2011-01-01';

but, I'd like to do this in one query, how would I do that?
Any suggestions would be appreciated. Thanks

Answer 1

0

So, what you want is to select Active projects OR projects that are closed with a completion date after 2011-01-01:

SELECT * FROM TABLE
WHERE (PROJECT_STATUS LIKE 'ACTIVE')
   OR ( (PROJECT_STATUS LIKE 'CLOSED') AND (COMPLETION-DATE > '2011-01-01') )

answered Mar 19 '12 at 10:02 PM

ThomasRushton ♦
30.1k ● 7 ● 10 ● 40

Great - that was real easy, thanks for your help!

Mar 20 '12 at 12:52 AM TelepathicSheep2

(comments are locked)