We help IT Professionals succeed at work.

Using multiple AND's and OR's

rvcw
rvcw asked
on
Medium Priority
486 Views
Last Modified: 2012-08-15
Hi,

I have the following query which basically, I want it to do the following:

select the field tblhostingaddons where the status is pending and the hostingid is 1
then
select one that has either the addonid 1 or the addonid 2.

The conditions that the status is pending and the hostingid is 1 must be there, but the condition for addonid can be either 1 or 2.

This is my query:

"SELECT id FROM tblhostingaddons WHERE status='Pending' AND hostingid='1' AND addonid=1 OR addonid =2"

However, it's not following my conditions that the status must be pending. It's choosing one where the status isn't pending which is wrong.

Any ideas where I'm going wrong here?
Comment
Watch Question

Fixer of Problems
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
Try grouping the addonid ...

"SELECT id FROM tblhostingaddons WHERE status='Pending' AND hostingid='1' AND (addonid=1 OR addonid =2)"

Open in new window

Explore More ContentExplore courses, solutions, and other research materials related to this topic.