asked
Select Statement, Where clause help - need to select active projects & closed projects from this year
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
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') )
3 People are following this question.
