November 11th, 2002, 11:37 PM
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?
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
November 12th, 2002, 04:35 AM
Read this article, that points out the old (non standard) and the new sql syntax for joins in Oracle.
November 12th, 2002, 09:45 PM
thanks for the article.
helped a lot.