Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL JOINS

Re: SQL JOINS

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 30 Sep 2004 16:52:44 -0400
Message-ID: <romdnU-yI9bZ78HcRVn-uQ@comcast.com>

"DCP" <vaagh_at_hotmail.com> wrote in message news:694b8886a926f0e9e0fdc2a7cbf03c8c_at_localhost.talkaboutdatabases.com...
| Its working with (+), but i want full outer join for tables. so how i have
| to do that in 8i, we can't put (+) on both sides, that gives an error
|

you've got to do a UNION of the left outer join and the right outer join :-(

++ mcs Received on Thu Sep 30 2004 - 15:52:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US