and or in query
Posted: Sat Nov 12, 2005 8:06 am
i am making a dynamic select query but what i wanna do is have a and with some or's in it. i wanna do somthing like
but i want to not have all those OR 1 of the table4's i want it to be like AND if 1 of those 4's are equal to one of the values. understand?
Code: Select all
WHERE
table1 = gwarrrr
AND
table2 = bloort
AND
table3 = oneht
AND
table4 = one
OR
table4 = two
OR
table4 = three