Join Two Sql Queries [Resolved]

DECLARE @TB1 TABLE
(
	TypeId int, 
	[Type] varchar(50),
	Credit int,
	Debit int
)


INSERT INTO @TB1
SELECT 1,'FD',5,5
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

DECLARE @TB2 TABLE
(
	TypeId int,    
	[Type] varchar(50),
	Leaves int,
	Accruable int,
	Accrued int
)

Declare @EmpGradeId uniqueidentifier = null
Select @EmpGradeId = EmpGradeId From tblEmp Where EmpCode='E1'

INSERT INTO @TB2
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


SELECT A.TypeId, Credit, Debit, Accrued
FROM @TB1 A inner join @TB2 B
ON A.TypeId = B.TypeId

Declare @EmpGradeId uniqueidentifier = null 
 
Select @EmpGradeId = EmpGradeId From tblEmp Where EmpCode='E1' 

;WITH LeaveDetails
AS (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 
), Accruables
(Select G.TypeId, L.Type, G.Leaves, G.Accruable, 
 Case When G.Accruable = 1 Then (G.Leaves*Month(GetDate())) Else G.Leaves END AS Accrued 
  From tblGrade G 
 Join tblType L On G.TypeId = L.TypeId 
 Where G.GradeId = @EmpGradeId)
  SELECT a.Type, a.Credit, a.Debit, l.Accrued
 FROM Accruables a 
 JOIN LeaveDetails l ON a.TypeId = l.TypeId AND a.Type = l.Type
 

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif