Query 1:
Select T.TypeId, L.Type, SUM(T.Credit)Credit,SUM(T.Debit)Debit
From tblTransactions T
Join tblType L on T.TypeId = L.TypeId
Where T.EmpCode='E1'
Group By T.TypeId, L.Type
TypeId Type Credit Debit
-------------------------
10 AL 0 2
20 CL 6 0
Query 2:
Declare @EmpGradeId uniqueidentifier = null
Select @EmpGradeId = EmpGradeId From tblEmp Where EmpCode='E1'
Select G.TypeId, L.Type, G.Leaves, G.Accruable,
'Accrued' = Case When G.Accruable = 1 Then (G.Leaves*Month(GetDate())) Else G.Leaves END
From tblGrade G
Join tblType L On G.TypeId = L.TypeId
Where G.GradeId = @EmpGradeId
TypeId Type Leaves Accruable Accrued
--------------------------------------
10 AL 5 1 5
20 CL 2 0 2
I would like to join these 2 queries and get a result like
Type Credit Debit Accrued
--------------------------
AL 0 2 5
CL 6 0 2
Tried this - but it gives only first result set.
Declare @EmpGradeId uniqueidentifier = null
Select @EmpGradeId = EmpGradeId From tblEmp Where EmpCode='E1'
Query1 union all query2