How to solution show result this sql on PHPMaker ?
SELECT x.FieldA, x.FieldB, x.FieldC, x.FieldD FROM (
SELECT 'Penerimaan' AS FieldA, FieldB, FieldC, SUM(FieldX) AS FieldC FROM t1 GROUP BY FieldB, FieldC
UNION
SELECT 'Pengeluaran' AS FieldA, FieldB, FieldC, SUM(FieldX) AS FieldC FROM t2 GROUP BY FieldB, FieldC
) x
ORDER BY FieldB, FieldC