Hi
I would like to combine a query over 2 tables and add the same columns. I found a solution with UNION, unfortunately it does not work with WP Data Table. Is there an alternative? Here is the query:

SELECT t.masch_nr,
       t.Monat,
       SUM(t.SOLLRüsten) AS SOLLRüsten,
       SUM(t.SOLLProduktion) AS SOLLProduktion,
       SUM(t.SOLLZuschlag) AS SOLLZuschlag,
       SUM(t.ISTRüsten) AS ISTRüsten,
       SUM(t.ISTProduktion) AS ISTProduktion
FROM  
(SELECT p.masch_nr
        ,SUM(b.ruest_zeit) as SOLLRüsten
        ,SUM(b.bearb_zeit) as SOLLProduktion
        ,SUM(b.ruest_zeit_zuschl) as SOLLZuschlag
        ,SUM(p.bmk_07) as ISTRüsten
        ,SUM(p.bmk_11) as ISTProduktion 
        ,MONTH(p.anmeld_dat) as Monat
FROM [hydra1].[hydadm].[ade_protokoll] p
JOIN [hydra1].[hydadm].[auftrags_bestand] b
  ON p.auftrag_nr = b.auftrag_nr
WHERE p.masch_nr = 'GEORG'
     AND satz_art = 'E'
GROUP BY p.masch_nr, MONTH(anmeld_dat)
UNION 
SELECT p.masch_nr
       ,SUM(b.ruest_zeit) as SOLLRüsten
       ,SUM(b.bearb_zeit) as SOLLProduktion
       ,SUM(b.ruest_zeit_zuschl) as SOLLZuschlag
       ,SUM(p.bmk_07) as ISTRüsten
       ,SUM(p.bmk_11) as ISTProduktion 
       ,MONTH(p.anmeld_dat) as Monat
FROM [hydra1].[hydadm].[v_ade_protokoll] p
JOIN [hydra1].[hydadm].[v_auftrags_bestand] b
  ON p.auftrag_nr = b.auftrag_nr
WHERE p.masch_nr = 'GEORG'
      AND satz_art = 'E'
GROUP BY p.masch_nr, MONTH(anmeld_dat)
) t
GROUP BY t.masch_nr, t.Monat
ORDER BY t.Monat