[Resolved] Query Question

[ljschrenk]

Hi,

I seem to be having a brain block on a concept problem. I'm running a query and I don't think I quite understand how ANDs and ORs work in relation to eachother.

Here's the query:

SELECT * FROM church_info church, service_times service WHERE church.attendance='3' AND church.loc_id='9' AND church.ID='1'OR church.ID='2'OR church.ID='3'OR church.ID='4'OR church.ID='9'OR church.ID='10'

I want it to select where attendance = 3, location = 9, and ID = 1
Or
where attendance =3, location = 9, and ID =2

But once it gets to the ORs it selects everyone where ID = 1, or 2, or 3 etc.

Am I making sense?

Any insight would be great!!
Thanks!
Lisa

[stolzyboy]

you want it to select when att is 3, loc is 9, and when id is 1 or 2, no others?

[csousley]

Try this:

SELECT * FROM church_info church, service_times service WHERE (church.attendance='3') AND (church.loc_id='9') AND ((church.ID='1') OR (church.ID='2') OR (church.ID='3') OR (church.ID='4') OR (church.ID='9') OR (church.ID='10'))

I ran into this one time and had to seperate everything with ()'s to get it working. You also had no spaces before all your 'OR' s.

Let me know if this doesn't work.

[ljschrenk]

I want it to select

when att = 3, loc = 9, id = 3
or
when att = 3, loc = 9, id = 4
or
when att = 3, loc = 9, id = 9

I want the query to maintain the attendance and location requirements for each id.

Right now, once it gets to the OR statements, it completely ignores the fact that I have AND for attendance and location.

[ljschrenk]

Thanks csousley,

I'll give it a try!

Lisa

[stolzyboy]

you may also want to give this a try

SELECT * FROM church_info church, service_times service
WHERE attendance = '3'
AND loc_id = '9'
AND ((ID = '3') OR (ID = '4') OR (ID = '9'))

[ljschrenk]

Thanks guys!

Your suggestions helped a lot and I think I have that problem figured out. It even makes more sense now too. 😃

Lisa