 Left Outer Join [message #324539] |
Tue, 03 June 2008 00:53  |
|
|
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 #324546 is a reply to message #324539] |
Tue, 03 June 2008 01:46  |
|
|
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 |
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
