Left and Right joins in Oracle
From: GV <gvf_at_retemail.es>
Date: 20 Mar 2002 08:33:55 -0800
Message-ID: <43519e78.0203200833.65b4177c_at_posting.google.com>
Date: 20 Mar 2002 08:33:55 -0800
Message-ID: <43519e78.0203200833.65b4177c_at_posting.google.com>
Hi,
Im new to oracle and I've read some oracle documentation regarding
left and right joins....the thing is that I've read that is beter to
use the ANSI notation instead of oracles (+) operator, the problem is
that an ansi select such as:
SELECT *
FROM a LEFT JOIN b ON a.x=b.y;
gives an error: ORA-00933: SQL command not properly ended
So I have to use the following syntax:
SELECT *
FROM a,b WHERE a.x=(+)b.y;
Is this the right way to proceed?
Thankyou very much,
Gonzalo
Received on Wed Mar 20 2002 - 17:33:55 CET