mas2..mbak2...
ada yang tau maksud sql dari query outer join,left
join gak?saya punya permasalahan di program saya yg
query nya spt ini(agak mbulet...let...let)
query :
INSERT INTO set_tunggakan_detil
(noagenda, bulan, idpel, kdpp, unitup,
goltarif, daya, golpiutang,nama, alamat,
rptag, rpptl,
rpmat, rpppn, rpbpju, rptrafo,
rpangsa, rpangsb, rpangsc)
SELECT '050506-01', a.bulan, a.idpel,
a.kdpp, a.unitup, a.goltarif, a.daya,
a.golpiutang, a.nama, a.alamat, a.rptag,
a.rpptl, a.rpmat, a.rpppn,
a.rpbpju, a.rptrafo, a.rpangsa,
a.rpangsb, a.rpangsc
FROM dpp_lancar a, dph_sementara b
WHERE a.idpel = b.idpel(+)
AND a.bulan = b.bulan(+)
AND b.idpel IS NULL
AND a.bulan = '200505'
AND a.idpel = '431000074705'
AND a.unitup = '43100'
tolong yaa......:)
Discover Yahoo!
Have fun online with music videos, cool games, IM and more. Check it out!
http://discover.yahoo.com/online.html
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
