Re: SQL JOINS
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 30 Sep 2004 16:52:44 -0400
Message-ID: <romdnU-yI9bZ78HcRVn-uQ_at_comcast.com>
Date: Thu, 30 Sep 2004 16:52:44 -0400
Message-ID: <romdnU-yI9bZ78HcRVn-uQ_at_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 - 22:52:44 CEST