Multiple Criteria In SQL Statement
Hi
I was just wondering if it is possible to specify multiple criterias in one SQL statement such as selecting results where a particular field equals no AND another filed has to be between two dates. I know you cant use multiple where clauses, so I have no idea how its done.
Help appreicated
Re: Multiple Criteria In SQL Statement
Is this what you are looking for?
Code:
Select * from table where a=y and datevalue between date1 and date2
You can have as many criteria as you want to include using AND and OR in the WHERE clause