Hello,
i have these two SQLs. Both SQLs select on the same table:
SELECT tab01.brnr ,
SUM(CASE WHEN tab01.AQEQ = 1 then 1 ELSE 0 END) AS ABST,
From MY_TABLE tab01
WHERE
tab01.VOAT IN (10,20) AND
tab01.DATECOL < TO_DATE(20200301, 'YYYYMMDD')
GROUP BY tab01.brnr;
LEC tab02.brnr , SU(CASE WHEN tab02.AQEQ = 2 then 1 ELSE 0 END) AS ENDST,
SELECT tab02.brnr ,
SUM(CASE WHEN tab02.AQEQ = 2 then 1 ELSE 0 END) AS ENDST,
From MY_TABLE tab02
WHERE
tab02.VOAT IN (10,20) AND
tab02.DATECOL >= TO_DATE(20200301, 'YYYYMMDD')
GROUP BY tab02.brnr;
How can i join these two SQLs? So i have something like this:
SELECT tab01.brnr, tab01.ABST, tab02.ENDST
from .....
Can someone help please?
Thank you very much
Best regards
George