 Left Outer Join [message #324539] |
Tue, 03 June 2008 00:53  |
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
