Re: select question

On Tue, Aug 21, 2001 at 02:21:49PM +0100, Scott Chapman wrote: > Hi, > > When doing a select of the form > > SELECT blah FROM blah WHERE blah=blah AND blah=blah; > > is there any way of doing it with an OR ie;- > > SELECT blah FROM blah WHERE blah=blah OR blah=blah; > > or any other way in which I could do something similar? > > thanks in advance > lee You pretty much gave the answer yourself, didn't you?! SELECT blah FROM blah WHERE blah=blah OR blah=blah; is exactly how you should do an "OR-SELECT-statement". -- * R&zE: -- »»»»»»»»»»»»»»»»»»»»»»»» -- Renze Munnik -- DataLink BV -- -- E: renze@datalink.nl -- W: +31 23 5326162 -- F: +31 23 5322144 -- M: +31 6 21811143 -- -- Stationsplein 82 -- 2011 LM HAARLEM -- Netherlands -- -- http://www.datalink.nl -- ««««««««««««««««««««««««