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
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.
cheers
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.