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>


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

Original text of this message