tb1 Name Salary Bob 1000 Tom 2000 John 3000 Winson 4000 tb2 Name Bonus Bob 100 Tom 200 I would like to get the following result Name Total Bob 1100 Tom 2200 John 3000 Winson 4000
SELEC tb1.Name, SUM(tb1.Salary + tb2.Bonus) Total From tb1, tb2 WHERE tb1.Name = tb2.Name group by tb1.Name order by Total
SELECT t1.Name, COALESCE(t1.Salary + t2.Bonus, t1.Salary, t2.Bonus) AS Total FROM tb1 t1 LEFT JOIN tb2 t2 ON t1.Name = t2.Name
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip