Re: Using a Select as a Var??

> > On Jul 5, 5:50 pm, valigula <valig..._at_gmail.com> wrote:
>
> > > Hi All
> > > Need top repeat a select 3 times but with differents where condition.
> > > I tried to repeat the selects and after use a couple of union to join
> > > then, but it takes toooo long.

Instead of UNION you could use OR in your WHERE clause.

Select * from sometable where name = 'JOHN' union
Select * from sometable where salary > 500 union
Select * from sometable where state <> 'NY';

Select * from sometable where name = 'JOHN' OR salary > 500 OR state <> 'NY';

If your queries take too long, try and index the tables. The index fields must match your WHERE fields. Received on Thu Jul 05 2007 - 11:33:16 CDT