filtering queries
Posted: Sat Jan 20, 2007 3:42 am
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
SELECT pubID, pubName, pubPostcode FROM Pubs
WHERE pubID=3 OR pubID=4 OR pubID=6
TIA