Page 1 of 1

filtering queries

Posted: Sat Jan 20, 2007 3:42 am
by garry27
is there an 'or' command in sql or an alternative i could use.i want to filter a select query by specific values, something like this:

SELECT pubID, pubName, pubPostcode FROM Pubs
WHERE pubID=3 OR pubID=4 OR pubID=6

TIA

Posted: Sat Jan 20, 2007 4:15 am
by Ollie Saunders
Yes there is, there is also IN too. You are using OR correctly in the example you posted.