On Wed, Feb 27, 2008 at 5:26 PM, danyschaer <schaer@...> wrote:

> Hi All,
>
> Maybe one of you can tell me what is wrong it this sintaxis:
>
> select * from (
> (select "ESTA"."PROC" from "ESTA" where "ESTA"."TEST" = '0002tem3IL')
> union
> (select "ESTA"."PROC" from "ESTA" where "ESTA"."TEST" = '0002tKr&uQ')
> )

This select does not really make much sense to me. I think what you
are trying to achieve is this:

select "ESTA"."PROC" from "ESTA" where "ESTA"."TEST" in ('0002tem3IL',
'0002tKr&uQ')

But in your original statement you are missing the table name after the from.

All the best,

Fidel.