> > >         select *
> > >         from tabA
> > >         where col1 = (select col2
> > >                       from tabB
> > >                       where tabA.col3 = tabB.col4
> > >                       and exists (select *
> > >                                   from tabC
> > >                                   where tabB.colX = tabC.colX and
> > >                                         tabC.colY = tabA.col2)
> > >                      )

I checked this in Informix, it works.

Andreas

Mon, 12 Jan 1998 11:25:00 +0100
Zeugswetter Andreas DBT <Andreas.Zeugswetter@telecom.at>
nested subselects are allowed