rendered paste bodyThe current sql statement:
(select "Header",invoice_no, sum(balance), sum(paid), sum(due), sum(finalBalance) from invoicePayments where invoice_no between 185150 and 185159 group by invoice_no) union
(select "footer",invoice_no, balance, paid, due, finalBalance from invoicePayments where invoice_no between 185150 and 185159);
The current output:
+--------+------------+--------------+-----------+----------+-------------------+
| Header | invoice_no | sum(balance) | sum(paid) | sum(due) | sum(finalBalance) |
+--------+------------+--------------+-----------+----------+-------------------+
| Header | 185150 | 56.1 | 0 | 56.1 | 56.1 |
| Header | 185151 | 313.27 | 0 | 313.27 | 313.27 |
| Header | 185152 | 92.09 | 0 | 92.09 | 92.09 |
| Header | 185153 | 62.84 | 0 | 62.84 | 62.84 |
| Header | 185154 | 249.79 | 0 | 249.79 | 249.79 |
| Header | 185155 | 354.87 | 0 | 354.87 | 354.87 |
| Header | 185156 | 204.22 | 0 | 204.22 | 204.22 |
| Header | 185157 | 247.8 | 0 | 247.8 | 247.8 |
| Header | 185158 | 265.5 | 0 | 265.5 | 265.5 |
| Header | 185159 | 52 | 25.5 | 26.5 | 23.5 |
| footer | 185150 | 56.1 | 0 | 56.1 | 56.1 |
| footer | 185151 | 313.27 | 0 | 313.27 | 313.27 |
| footer | 185152 | 92.09 | 0 | 92.09 | 92.09 |
| footer | 185153 | 62.84 | 0 | 62.84 | 62.84 |
| footer | 185154 | 249.79 | 0 | 249.79 | 249.79 |
| footer | 185155 | 97.47 | 0 | 97.47 | 97.47 |
| footer | 185155 | 257.4 | 0 | 257.4 | 257.4 |
| footer | 185156 | 125.68 | 0 | 125.68 | 125.68 |
| footer | 185156 | 78.54 | 0 | 78.54 | 78.54 |
| footer | 185157 | 247.8 | 0 | 247.8 | 247.8 |
| footer | 185158 | 265.5 | 0 | 265.5 | 265.5 |
| footer | 185159 | 15.5 | 15.5 | 0 | 0 |
| footer | 185159 | 23.5 | 0 | 23.5 | 23.5 |
| footer | 185159 | 13 | 10 | 3 | 0 |
+--------+------------+--------------+-----------+----------+-------------------+
The desired output:
+--------+------------+--------------+-----------+----------+-------------------+
| Header | invoice_no | sum(balance) | sum(paid) | sum(due) | sum(finalBalance) |
+--------+------------+--------------+-----------+----------+-------------------+
| Header | 185150 | 56.1 | 0 | 56.1 | 56.1 |
| footer | 185150 | 56.1 | 0 | 56.1 | 56.1 |
| Header | 185151 | 313.27 | 0 | 313.27 | 313.27 |
| footer | 185151 | 313.27 | 0 | 313.27 | 313.27 |
| Header | 185152 | 92.09 | 0 | 92.09 | 92.09 |
| footer | 185152 | 92.09 | 0 | 92.09 | 92.09 |
| Header | 185153 | 62.84 | 0 | 62.84 | 62.84 |
| footer | 185153 | 62.84 | 0 | 62.84 | 62.84 |
| Header | 185154 | 249.79 | 0 | 249.79 | 249.79 |
| footer | 185154 | 249.79 | 0 | 249.79 | 249.79 |
| Header | 185155 | 354.87 | 0 | 354.87 | 354.87 |
| footer | 185155 | 97.47 | 0 | 97.47 | 97.47 |
| footer | 185155 | 257.4 | 0 | 257.4 | 257.4 |
| Header | 185156 | 204.22 | 0 | 204.22 | 204.22 |
| footer | 185156 | 125.68 | 0 | 125.68 | 125.68 |
| footer | 185156 | 78.54 | 0 | 78.54 | 78.54 |
| Header | 185157 | 247.8 | 0 | 247.8 | 247.8 |
| footer | 185157 | 247.8 | 0 | 247.8 | 247.8 |
| Header | 185158 | 265.5 | 0 | 265.5 | 265.5 |
| footer | 185158 | 265.5 | 0 | 265.5 | 265.5 |
| Header | 185159 | 52 | 25.5 | 26.5 | 23.5 |
| footer | 185159 | 15.5 | 15.5 | 0 | 0 |
| footer | 185159 | 23.5 | 0 | 23.5 | 23.5 |
| footer | 185159 | 13 | 10 | 3 | 0 |
+--------+------------+--------------+-----------+----------+-------------------+