Re: query with =ALL

Hi all,

> > AND
> > CPA.cur_paralelo = ALL (SELECT cur_paralelo FROM aca_t_curso ...)
>
>Wait a second ... we are all overthinking the problem.  The subselect
>returns three *different* values.  It is not possible for any
>CPA.cur_paralelo values to be simultaneously equal to all three.
>So this test certainly fails at every row of CPA.
>
>Perhaps you meant "= ANY"?

Not really becuase ANY has the same efect that IN and what i want is all the 
results that are equal in all the rows in any of the cur_paralelo values. 
But must be in all the cur_paralelo or nothing.

thanx in advance,

Jaime Casanova

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. 
http://join.msn.com/?page=features/virus