سلام
دوستان یه مشکلی برای من پیش اومده. می خواستم بدونم چطوری میشه دو کوئری زیر رو باهم ادغام کرد:
دوستان یه مشکلی برای من پیش اومده. می خواستم بدونم چطوری میشه دو کوئری زیر رو باهم ادغام کرد:
Select
, A.ID
Sum(B.Amount) As TotalAmount
From tb1 As A
Inner Join tb2 As B
On (A.ID = B.ID)
where A.Type = 1
Group By
A.ID
Query2:
Select
, A.ID
Sum(C.Amount) As TotalAmount
From tb1 As A
Inner Join tb3 As C
On (A.ID = C.ID)
where A.Type = 2
and C.Date < Today
Group By
A.ID
, A.ID
Sum(B.Amount) As TotalAmount
From tb1 As A
Inner Join tb2 As B
On (A.ID = B.ID)
where A.Type = 1
Group By
A.ID
Query2:
Select
, A.ID
Sum(C.Amount) As TotalAmount
From tb1 As A
Inner Join tb3 As C
On (A.ID = C.ID)
where A.Type = 2
and C.Date < Today
Group By
A.ID