Home » Other » Training & Certification » Left Outer Join (Oracle 9i & 10g, Windows)
icon6.gif  Left Outer Join [message #324539] Tue, 03 June 2008 00:53 Go to next message
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member


Hi,

Can any one tell me which one of the following is considered as LEFF OUTER JOIN.

i.e. which one is equivalent to

SELECT *
FROM CITY LEFT OUTER JOIN STATE USING (CITY_CD);


A. SELECT * 
FROM STATE, CITY
WHERE STATE.CITY_CD (+) = CITY.CITY_CD;

B. SELECT * 
FROM CITY, STATE
WHERE STATE.CITY_CD (+) = CITY.CITY_CD;

C. SELECT * 
FROM STATE, CITY
WHERE CITY.CITY_CD = STATE.CITY_CD (+);

D. SELECT * 
FROM CITY, STATE
WHERE CITY.CITY_CD = STATE.CITY_CD (+);




Thanks,
Priya.

[Updated on: Tue, 03 June 2008 01:03] by Moderator

Report message to a moderator

Re: Left Outer Join [message #324542 is a reply to message #324539] Tue, 03 June 2008 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the genuine Oracle syntax, there is no "left" or "right" outer join, there is just "outer join" as there can be no ambiguity with this syntax.

Regards
Michel
icon6.gif  Re: Left Outer Join [message #324546 is a reply to message #324539] Tue, 03 June 2008 01:46 Go to previous messageGo to next message
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member

Hi,

Quote:

In the genuine Oracle syntax, there is no "left" or "right" outer join, there is just "outer join" as there can be no ambiguity with this syntax.


So none of the mentioned SQL statements can be considered as LEFT OUTER JOIN or RIGHT OUTER JOIN.

Thanks,
Priya.

[Updated on: Tue, 03 June 2008 01:55] by Moderator

Report message to a moderator

Re: Left Outer Join [message #324549 is a reply to message #324546] Tue, 03 June 2008 01:55 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In my opinion, none.

Regards
Michel
Previous Topic: Good Beginners Books
Next Topic: Query
Goto Forum:
  


Current Time: Thu Mar 28 17:51:02 CDT 2024