Hello ,
mau tanya sehabis union all, hasil datanya baru di group lagi
berdasarkan cd_barang caranya bagaimana ya ?
tks
select
a.cd_barang,
a.s_pcs,
a.s_harga
from
stock a
union all
select
b.cd_barang,
sum(b.pcs) as t_pcs,
sum(b.harga) as t_harga
from
terima b
group by
b.cd_barang
union all
select
c.cd_barang,
sum(c.pcs)*(-1) as t_pcs,
sum(c.harga)*(-1) as t_harga
from jual c
group by
c.cd_barang
--
Best regards,
fansul
mailto:[email protected]
__________________________________________________
Apakah Anda Yahoo!?
Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam
http://id.mail.yahoo.com
