Buat program pln yaaa...
SIP3 apa warehouse??
maksudnya adalah
insert ->(field berikut ini)
noagenda, bulan, idpel, kdpp, unitup,
goltarif, daya, golpiutang,nama, alamat,
rptag, rpptl, rpmat, rpppn, rpbpju, rptrafo,
rpangsa, rpangsb, rpangsc
datanya ngambil dari query
(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(+) -> semua idpel di a atau
kebalik yaa...(lupa... pokoknya salah satu kalo ngga a
ya b)
AND a.bulan = b.bulan(+) -> sama kaya diatas tapi
kasusnya sekarang bulan
{AND b.idpel IS NULL
AND a.bulan = '200505'
AND a.idpel = '431000074705'
AND a.unitup = '43100'}->udah jelas kan? )
--- 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
>
Discover Yahoo!
Get on-the-go sports scores, stock quotes, news and more. Check it out!
http://discover.yahoo.com/mobile.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/
