coba ini :
select z.cd_comp,z.nomor,z.tanggal,z.cd_sup,
y.jenis_uang,y.zhari,y.kurs
from (SELECT a.po_cd_comp AS cd_comp, a.po_nomor AS nomor,
a.po_tanggal AS tanggal, a.po_cd_sup AS cd_sup
FROM po_mutasi a
WHERE a.po_pcs_sisa > 0
GROUP BY a.po_cd_comp, a.po_nomor, a.po_tanggal, a.po_cd_sup
) z,
( SELECT b.po_jenis_uang AS jenis_uang, b.po_zhari AS zhari, b.po_kurs
AS kurs
FROM po_header b
) y
where z.po_cd_ comp (+) = y.po_cd_ comp
and z.po_nomor (+) = y.po_nomor
kalo salah pindah2 in aja tanda (+) nya
________________________________
From: "[email protected]" <[email protected]>
To: [email protected]
Sent: Monday, September 28, 2009 10:49:03 AM
Subject: [indo-oracle] subquery + left join
Hello,
saya punya 2 table, satu harus di group dulu baru di left join
maunya saya yang jadi induk itu yang di group dulu, baru di bawahnya
left join.
mohon solusinya.
Ini yang di group
select
a.po_cd_comp as cd_comp,
a.po_nomor as nomor,
a.po_tanggal as tanggal,
a.po_cd_sup as cd_sup
from
po_mutasi a
where
a.po_pcs_sisa > 0
group by
a.po_cd_comp,
a.po_nomor,
a.po_tanggal,
a.po_cd_sup
Ini yang mau di left join.
select
b.po_jenis_uang as jenis_uang,
b.po_zhari as zhari,
b.po_kurs as kurs
from
po_header b
Sementara yang saya lakukan seperti ini, apakah udah benar
saya takut setelah datanya banyak, akibatanya lambat.
create or replace view lookup_trm_langsung _po_header as
select
a.po_cd_comp as cd_comp,
a.po_nomor as nomor,
a.po_tanggal as tanggal,
a.po_cd_sup as cd_sup,
b.po_jenis_uang as jenis_uang,
b.po_zhari as zhari,
b.po_kurs as kurs
from
po_mutasi a
left join po_header b
on trim(a.po_cd_ comp) = trim(b.po_cd_ comp)
and trim(a.po_nomor) = trim(b.po_nomor)
where
a.po_pcs_sisa > 0
group by
a.po_cd_comp,
a.po_nomor,
a.po_tanggal,
a.po_cd_sup,
b.po_jenis_uang,
b.po_zhari,
b.po_kurs;
--
Best regards,
fansul
mailto:fan...@yahoo. co.id
____________ _________ _________ _________ _________ __
Apakah Anda Yahoo!?
Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam
http://id.mail. yahoo.com
[Non-text portions of this message have been removed]
