Oracle outer join syntax in MySQL
I'm migrating some views from Oracle and am having a rough time getting the outer join syntax correct. This is an example view. Can someone take a shot at fixing it for MySQL? I wish MySQL supported the (+) shortcut.
CREATE OR REPLACE VIEW `wims`.`v_monitor_loc` AS
SELECT MONITOR_LOC_ID,
MONITOR_LOC_CODE,
MONITOR_LOC_NAME,
MONITOR_LOC_DESCRIPTION,
LOOK.LL_DESCRIPTION LOCATION_TYPE,
Y_LAT_DEC,
X_LON_DEC,
Z_ELEVATION,
HM.LL_DESCRIPTION HORIZ_METHOD,
HA.LL_DESCRIPTION HORIZ_ACCURACY,
HD.LL_DESCRIPTION HORIZ_REF_DATUM,
LL_ID_LOCATION_TYPE,
VERT_UNIT_ID
FROM ED_MONITOR_LOC L, ED_LOOKUP LOOK,
V_HORIZ_ACCURACY HA, V_HORIZ_METHOD HM,
V_HORIZ_REF_DATUM HD
WHERE L.LL_ID_LOCATION_TYPE = LOOK.LL_ID
AND L.LL_ID_HORIZ_METHOD = HM.LL_ID (+)
AND L.LL_ID_HORIZ_ACCURACY = HA.LL_ID (+)
AND L.LL_ID_HORIZ_REF_DATUM = HD.LL_ID (+);
Subject
Views
Written By
Posted
Oracle outer join syntax in MySQL
5906
November 29, 2006 09:35PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.