0

hi,

i have read around and all i seem to find is one and in the where clause along with an OR or either but i was wondering if it was fine to use 2 or maybe 3 AND in the where clause?

most of my where clauses in past as still learning i have only had 1 AND or an OR in the query.

probably simple question but just want to make sure i wont have any issues.

many thanks

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by andydeans
1

You can use as many as you need. Just be careful when using both AND and OR. Make sure you use parenthesis, so it does exactly what you want, otherwise you may get unexpected results.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.