#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2002
    Location
    KL, Malaysia
    Posts
    2
    Rep Power
    0

    ANSI SQL-92 to Oracle


    Hi guys, I have this SQL statement in ANSI SQL-92. I just found out that Oracle 8i doesn't support ANSI SQL-92 for left joins. How do I translate it to Oracle's native SQL?

    Code:
    select 
    a.no_gaji, 
    a.nama, 
    a.no_kp, 
    a.no_tel, 
    a.staf_ketagori, 
    a.trk_lahir, 
    a.trk_lantikan, 
    a.kod_warga, 
    a.kod_jab, 
    a.taraf_khidmat, 
    a.no_kwsp, 
    a.tkh_tamat_kontrak, 
    b.gaji, c.per_jab, 
    d.per_warga, 
    e.per_khidmat from gaj_induk a 
    left join gaj_jadual2 b on (a.kod_gaji = b.kod_gaji and a.rank_gaji = b.rank_gaji and a.t_gaji = b.t_gaji) 
    left join gaj_kod_jab c on (a.kod_jab = c.kod_jab) 
    left join gaj_kod_warga d on (a.kod_warga = d.kod_warga) 
    left join gaj_kod_khidmat e on (a.taraf_khidmat = e.taraf_khidmat) 
    where a.no_gaji = 00000790
    .

    Thanks.
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2002
    Location
    KL, Malaysia
    Posts
    2
    Rep Power
    0
    thanks for the article.
    helped a lot.

    cheers.

IMN logo majestic logo threadwatch logo seochat tools logo