Begin SELECT b.id_area,c.id_periode, COUNT(a.cust) jmlkwitansi,COUNT(DISTINCT a.cust) jmlcustomer,SUM(a.rppembayaran) Rppembayaran FROM Koreksi a, D_AREA b,D_PERIODE c WHERE "kondisi yang diharapkan" EXCEPTION WHEN OTHERS THEN insert into Table_tujuan SELECT b.id_area,c.id_periode, COUNT(a.cust) jmlkwitansi,COUNT(DISTINCT a.cust) jmlcustomer,SUM(a.rppembayaran) Rppembayaran FROM Koreksi a, D_AREA b,D_PERIODE c WHERE b.area = a.area AND a.periode = c.priode; End;
[Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h5nppop/M=362329.6886308.7839368.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124189321/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
