"Biaya Langsung","SELECT M_BIAYA, M_NMBIAYA, SUM(BESAR) AS QTYB, SUM(KECIL) AS QTYK, SUM(JUMLAH) AS TOTAL FROM (SELECT M_BIAYA,M_NMBIAYA,M_KODE,BESAR,KECIL,JUMLAH FROM MSBIAYA AS A,(SELECT DISTINCT M_KODE,M_KDBIAYA FROM (SELECT M_KODE,M_KDBIAYA FROM MSINV UNION SELECT M_KODE,M_KDBIAYA FROM DTBIAYA)) AS B,  (SELECT SH_KDITEM,SUM(SH_Q_B) AS BESAR, SUM(SH_Q_K) AS KECIL,SUM(SH_JUMLAH) AS JUMLAH FROM (SELECT 'BL' AS JENIS, SH_KDITEM, SH_Q_B,SH_Q_K,SH_HARGA,SH_JUMLAH FROM DTBY AS A, HDBY AS B WHERE A.SH_NOSJ = B.SH_NOSJ AND B.SH_TRIP = '1' AND B.SH_TAHUN = 2003 AND B.SH_KDCUST = 'P19' UNION SELECT 'GD' AS JENIS, SH_KDITEM, SH_Q_B,SH_Q_K,SH_HARGA,SH_JUMLAH FROM DTSH AS A, HDSH AS B WHERE A.SH_NOSJ = B.SH_NOSJ AND B.SH_TRIP = '1' AND B.SH_TAHUN = 2003 AND B.SH_KDCUST = 'P19' ) GROUP BY SH_KDITEM) AS C WHERE A.M_BIAYA = B.M_KDBIAYA AND B.M_KODE = C.SH_KDITEM) GROUP BY M_BIAYA, M_NMBIAYA

"
"Gabungan BL dan GD","SELECT 'BL' AS JENIS, SH_KDITEM, SH_Q_B,SH_Q_K,SH_HARGA,SH_JUMLAH FROM DTBY AS A, HDBY AS B WHERE A.SH_NOSJ = B.SH_NOSJ AND B.SH_TRIP = '1' AND B.SH_TAHUN = 2003 AND B.SH_KDCUST = 'P19' UNION SELECT 'GD' AS JENIS, SH_KDITEM, SH_Q_B,SH_Q_K,SH_HARGA,SH_JUMLAH FROM DTSH AS A, HDSH AS B WHERE A.SH_NOSJ = B.SH_NOSJ AND B.SH_TRIP = '1' AND B.SH_TAHUN = 2003 AND B.SH_KDCUST = 'P19' "
