Re: porting complex outer join, sub-query
Great! Infact this will work. I forgot to mention that (+) is the operator
for outer joins in Oracle therefore the last part of the query would look
like this in Informix:
select V.x, V.y, X.x, X.y
from V, OUTER X
where V.x = X.x
and V.y = X.y;
Thanks a lot,
Thomas
---- Original Message -----
From: "Raju Iyer" <awkdude@hotmail.com>
To: <thomas_burkhardt@i2.com>
Sent: Friday, September 08, 2000 10:31 AM
Subject: re: porting complex outer join, sub-query
> Thomas ,
> Hope this helps, do check it out and let us know.- raju
>
> select A.x, B.y from A, B where A.x = 'vx' and B.y ='vy'
> into temp V;
> select C.x, C.y from C
> union all
> select D.x, D.y from D
> into temp X;
> select V.x, V.y, X.x, X.y
> from V,X
> where V.x = X.x (+)
> and V.y = X.y (+);>
>
> ----------
> From: Thomas Burkhardt [SMTP:thomas_burkhardt@i2.com]
> Sent: Thursday, September 07, 2000 7:30 PM
> To: informix-list@iiug.org
> Subject: porting complex outer join, sub-query
>
> I am trying to port a query similar to the following one from Oracle 8.04
to
> Informix Dynamic Server 2000:
> select V.x, V.y, X.x, X.y
> from (select A.x, B.y from A, B where A.x = 'vx' and B.y ='vy') V,
> (select C.x, C.y from C union all select D.x, D.y from D) X
> where V.x = X.x (+)
> and V.y = X.y (+)>
> I am an Informix novice. The first thing I learned is that sub-queries are
> not allowed in the from clause. However if that's not possible how could
you
> formulate this query in Informix?
>
> Any help is appreciated.
>
> Thanks,
> Thomas
>
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>