Re: Outer join

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Tue, 12 Feb 2002 14:24:00 +0400
Message-ID: <86rh6usvlfslugs277jt2r8ae4obqnbs8t@4ax.com>

SELECT * FROM

		tableA, 
		(Select TableB_Num from TableA, Table B
			Where tableB_Field1 = tableC_num) B
Where 	TableA_Num = TableB_Num(+)

Hope this works....

On 12 Feb 2002 00:27:41 -0800, prasad.kulkarni_at_mailcity.com (Prasad Kulkarni) wrote:

>Hello All,
>
>I have a problem with Outer join. I have to write a query in Oracle
>such that, first i hard join two tables to get a result set and then
>that result set is outer joined with a table. I can write the query in
>informix like this
> SELECT * FROM tableA, OUTER(tableB, tableC)
> WHERE tableA_num = tableB_num AND
> tableB_Field1 = tableC_num.
>
>Here first the tables tableB and tableC are hard joined and then they
>are outer joined with tableA.
>
>How can i do this in ORACLE.
>
>Regards
>Prasad

[Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Tue Feb 12 2002 - 04:24:00 CST