Re: Outer join

Hello,

Its working but it doesnt brint the columns from tables in the subquery if you dont give * in the first select statement

Regards
Prasad

Ganesh Raja <ganesh_at_gtfs-gulf.com> wrote in message news:<86rh6usvlfslugs277jt2r8ae4obqnbs8t_at_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 Wed Feb 13 2002 - 01:26:06 CST