JOIN PROBLEM SQL S65 <> ORACLE 7.3

From: Eric Euerlings <euerlings_at_swift.ch>
Date: Thu, 22 Oct 1998 17:27:06 +0200
Message-ID: <70niu9$ou7$1@bw107zhb.bluewin.ch>

Hi, I have to port SQL Server 6.5 to Oracle and have problem with the syntax of the joins.

I have a small sample from SQL SERVER and it goes like this:

create or replace view
  v_preisermittlung_eltern_daten(mandant,   partner_kind,
  partner_eltern,
  rabattstufe_eltern,
  preisgruppe_eltern,
  land_eltern,
  kanton_eltern)
  as select mandant_partner_a.mandant,
    mandant_partner_a.partner,
    eltern.partner_eltern,
    mandant_partner_b.partner_rabattstufe,     mandant_partner_b.preisgruppe,
    partner.land_wohn,
    partner.kanton
    from ECOopen.mandant_partner mandant_partner_a left outer join     ECOopen.eltern
    on mandant_partner_a.mandant=eltern.mandant     and mandant_partner_a.partner=eltern.partner_kind     and eltern.elt_amtl_postempf='0' left outer join     ECOopen.mandant_partner mandant_partner_b     on eltern.mandant=mandant_partner_b.mandant     and eltern.partner_eltern=mandant_partner_b.partner left outer join     ECOopen.partner
    on mandant_partner_b.partner=partner.partner ;

How would look this for Oracle ?
Any hints ?

Thanks in advance

Cherrs Eric Received on Thu Oct 22 1998 - 10:27:06 CDT