I have some confusing part in the sql command
the question is
i have 2 different query :
Select SUM(T1.Amount+T2.Amount) as Total From TABLE1 T1 INNER TABLE2 T2 ON T1.ID = T2.ID
Select Sum(Amount) as Total FROM TABLE3
the result if a) query is 100 and result of b) query is 50
But i wanna show the result is 150 (That means add query a) result and query b result.)
So what should i do?
I use INTERSECT to combine both query, but it shows "syntax error"
have any one to help me?