I tried a normal select query
select col_A, (select distinct 1 from Tab_A) from Tab_A
its working fine on Informix,
what sort of query u have can u post it on the group..
On 16 Jul 2006 21:58:36 -0700, firstname.lastname@example.org
> Hi All,
> I am trying to run an sql statement which is like select from (select)
> statement.This sql
> query works fine in oracle database & throws an error in informix.Is
> there any alternative
> way i which this sql statement can be run.Any help is highly
> Thanks in Advance.
> Informix-list mailing list