outer join

From: Oliver Stratmann <yxcsstratmoqwert_at_gmx.de>
Date: Thu, 4 Mar 2004 12:00:03 +0100
Message-ID: <c2727r$1q1du3$1@ID-180535.news.uni-berlin.de>

Hello Kurta!

Are You probably looking for an outer join like:

SELECT sav_id, sav_memb, classtype

FROM  t_svgs svgs,
      t_cm_basebase cmbs,
      t_um_base umbs

WHERE svgs.sav_memb = 66470
and svgs.cmbs_id = cmbs.sav_cm_base (+)
and svgs.umbs_id = umbs.sav_um_base (+);

Bye!
Oli Received on Thu Mar 04 2004 - 05:00:03 CST