I am querying current and archived invoices and using UNION to combine the results into one table. I’m using GROUP BY to control how the individual invoice lines (ii and iai) are summed. I then need to add in subtotals for groups of the unified data, so have tried to use a GROUP BY WITH… Read More Using UNION and GROUP BY WITH ROLLUP for two separate queries