Using multiple AND's and OR's

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?
rvcwAsked:
Who is Participating?
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
Try grouping the addonid ...

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

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.