Re: Full Join
Date: Wed, 04 Apr 2001 00:12:42 GMT
Message-ID: <_Fty6.64$4L4.48673_at_news1.frmt1.sfba.home.com>
Hi Bob,
Now that I know what a full join is, might I suggest
select a.abc, x.xyz from a,x where a.this = b.that (+)
union
select a.abc,x.xyz from a,x where a.this(+) = b.that and a.this is null;
I think this should work. If not, let me know because I know that conceptually it should work.
Mike
Robert E. Flaherty <Bobf_at_TimeVision.Com> wrote in message
news:3ac210f2_2_at_news.newsfeeds.com...
> Is it possible to do a Full Join in Oracle? If not, any suggestion to a
> work-around.
>
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Wed Apr 04 2001 - 02:12:42 CEST