Ok.. I have query that goes something like:
so that works fine and does the query as it should, but when i change it to:
it disregards the "uniquefield1" part and just shows anything the "sharedfield2" appears in. I'm guessing it is my use of AND/OR's...
Anyone know what the problem is?
Code:
SELECT * FROM table WHERE uniquefeild1 = '1' AND sharedfield1 = '1' OR uniquefield2 = '1'
so that works fine and does the query as it should, but when i change it to:
Code:
SELECT * FROM table WHERE uniquefeild1 = '1' AND sharedfield1 = '1' OR sharedfield2 = '1' OR uniquefield2 = '1'
it disregards the "uniquefield1" part and just shows anything the "sharedfield2" appears in. I'm guessing it is my use of AND/OR's...
Anyone know what the problem is?