Combine the result of two sql queries in two columns

Request 1:

SELECT COUNT (A.EMPNO) AS [PRESENT] FROM ERPDATA.NIITESS.DBO.ZEMP_MASXST_WEB_AL A INNER JOIN PPA_EVENTWISEEMPLOYEEMASTER B ON (CASE B.VC_BA WHEN '%' THEN LTRIM(RTRIM(A.PDIBUSHORT)) ELSE B.VC_BA END) = LTRIM(RTRIM(A.PDIBUSHORT)) AND (CASE B.VC_PA WHEN '%' THEN A.PA ELSE B.VC_PA END) = A.PA WHERE A.STATUS = 3 AND A.EMPNO IN (SELECT VC_EMPCODE FROM ERPDATA.NIITESS.DBO.ADA_MXEASTER WHERE IN_ATTENDANCE_STATUS = 1 AND CH_ACTIVE = 'Y' AND VC_EMPCODE <> '') GROUP BY B.IN_EVENTID 

Request 2:

 SELECT COUNT (A.EMPNO) AS [TOTAL] FROM ERPDATA.NIITESS.DBO.ZEMP_MASXST_WEB_AL A INNER JOIN PPA_EVENTWISEEMPLOYEEMASTER B ON (CASE B.VC_BA WHEN '%' THEN LTRIM(RTRIM(A.PDIBUSHORT)) ELSE B.VC_BA END) = LTRIM(RTRIM(A.PDIBUSHORT)) AND (CASE B.VC_PA WHEN '%' THEN A.PA ELSE B.VC_PA END) = A.PA WHERE A.STATUS = 3 

I want to combine two results in two columns with a missing column = query 2 - query 1 to speed up. How can I do it? EXAMPLE:
I have TWO RESULTS:
// ---------------------------------------- QUERY: 1
1
2
3
4
// -------------------------------------- QUERY: 2
4
5
6
eight

// ------------------------------------ OUTCOME AS in two columns
fifteen
2 6
3 7
4 8

+4
source share
1 answer
 Select a.C1-b.C2 as Res from ( Select Count(*) as C1 from Users Group by Name ) a join ( Select Count(*) as C2 from User2 Group by Name ) b ON 1=1 -- or desired condition if existing 
+4
source

All Articles