Mau kue?? kueri…..

opooooo ikiiiiii???

SELECT B.CLIENT_NAME,C.SUBCLIENTNAME,C.SUBCLIENTID,C.ACCOUNTNO,A.TRANS_FEE,  A.SAFE_CUS_FEE,A.VAT1,A.S4_CHARGES,A.COURIER_FEE,A.BOND,A.STAMP_DUTY,   (A.TRANS_FEE+A.SAFE_CUS_FEE+A.VAT1+A.S4_CHARGES+A.COURIER_FEE+A.BOND+A.STAMP_DUTY) AS TOTAL_FEE,
A.CREATED
FROM MGCPD A,SDCLN B,SDSCLN C
WHERE B.CLIENT_ID=A.BP_ID AND C.SUBCLIENTID=A.SCA_ID AND TO_CHAR(A.CREATED,’MM’)=8 AND TO_CHAR(A.CREATED,’YYYY’)=2008

select CLIENT_NAME from VW_30MI1,MGCPD WHERE VW_30MI1.CLIENT_ID=MGCPD.BP_ID

select SUBCLIENTNAME from VW_30MI1,MGCPD WHERE VW_30MI1.SUBCLIENTID=MGCPD.SCA_ID ORDER BY SUBCLIENTNAME

SELECT B.CLIENT_NAME,C.SUBCLIENTNAME,C.SUBCLIENTID,C.ACCOUNTNO,A.TRANS_FEE,A.SAFE_CUS_FEE,A.VAT1,A.S4_CHARGES,A.COURIER_FEE,
A.BOND,A.STAMP_DUTY,(A.TRANS_FEE+A.SAFE_CUS_FEE+A.VAT1+A.S4_CHARGES+A.COURIER_FEE+A.BOND+A.STAMP_DUTY) AS TOTAL_FEE,A.CREATED,to_char(sysdate,’MM’)-1
FROM MGCPD A,SDCLN B,SDSCLN C WHERE B.CLIENT_ID=A.BP_ID AND TO_CHAR(A.CREATED,’MM’)=8 AND TO_CHAR(A.CREATED,’YYYY’)=2008 AND
C.SUBCLIENTID=A.SCA_ID

SELECT B.NAMA_NPWP,A.TANGGAL_PKP,A.KODE_FAKTUR_PJK,A.VAT1,A.VAT2,A.VAT3,B.ADDRESS1,B.NPWP FROM MGCPD A, SDSCLN B WHERE A.SCA_ID=B.SUBCLIENTID

SELECT B.NAMA_NPWP,B.ADDRESS1,B.NPWP,A.TANGGAL_PKP FROM MGCPD A, SDSCLN B WHERE A.SCA_ID=B.SUBCLIENTID

select * from mgcpd

SELECT A.SCA_ID,B.SUBCLIENTID,B.NAMA_NPWP,B.ADDRESS1,B.NPWP,B.NPPKP,A.TANGGAL_PKP,A.KODE_FAKTUR_PJK,’+
‘A.TXN_CURR AS CURR,C.NOMINAL,A.VAT1 AS VAT,D.MONTH,(0.1*A.VAT1) AS PPN,’+
‘B.NPWP,A.TYPE_OF_CF,A.TANGGAL_BYR,TO_CHAR(SYSDATE,’+PETIK+’YYYY’+PETIK+’)'+
‘ AS TAHUN FROM MGCPD A, SDSCLN B, MCURR2 C, MONTHCONVERT D WHERE D.ID=TO_NUMBER(TO_CHAR(SYSDATE,’+PETIK+’MM’+PETIK+’))’+
‘ AND A.SCA_ID=B.SUBCLIENTID AND NAMA_NPWP=’+PETIK+ComboBox1.Text+PETIK+’ AND A.TXN_CURR=C.CURRENCY’;

hahahhahahahhahahaaaahahahha…

*cueeek…