Coba query nya simbol (+) diletakan sebelum simbol =
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'
--- momo caqep <[EMAIL PROTECTED]> wrote:
> 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
>
__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail
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/
