Re: Full join on Oracle?
From: Ilya Shambat <ishambat_at_aol.com>
Date: 11 Jun 2002 06:26:45 -0700
Message-ID: <d02408fc.0206110526.259b77e9_at_posting.google.com>
Date: 11 Jun 2002 06:26:45 -0700
Message-ID: <d02408fc.0206110526.259b77e9_at_posting.google.com>
brotherhou_at_yahoo.com (konghou) wrote in message news:<c19678a1.0206101821.1ebf95e2_at_posting.google.com>...
> Is there an equivalent of "full join in MS SQL" on Oracle?
Yes. You just do a join based on the columns.
Select a.col1, a.col2, a.col3, b.col1, b.col2
from objectsa a, objectsb b
where a.col1=b.col1.
Received on Tue Jun 11 2002 - 15:26:45 CEST