Re: SQL vs PL/SQL: FROM clause incompatible?

"P. Smith" <pam.smith_at_jhuapl.edu> wrote: [snip]
>
>-- the following select statement is accepted by SQL*PLUS
> SELECT var2 FROM
> (SELECT var2, var3 FROM mytable WHERE var1 = 1
> UNION
> SELECT var2, var3 FROM mytable WHERE var1 = 2);
>
>
Wow, I have never seen a select statement like that work. But what are you trying to do? Select var2 FROM 1,2 !!?

I suspect you are trying to do something like this

select var2
from mytable
where var1 in (1,2);

David George
BCIT
Disclaimer Received on Tue Jul 18 1995 - 00:00:00 CEST