Total Amount of all Employee

Bhupendra Singh

13y1.7k

I have two table

Employee table

Employeeid   Name   Department
1            AA        IT 
2            AB        SALES 
3            AA        IT


Employee Salary

Employeeid         Paydate        Mode      Amount
00001              2011-01-15     Cash       5000


00001              2011-05-15     Cash       5000



00003             2011-02-15     Cash       5000
00003             2011-02-15     Cheque     6000



i need the following out put

Employeeid   Amount
10001        10,000
10002        000000 
10003        11,000

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naveed Zaman13y ago
in my point of view its simple first of all you have to sum the amount in you second table using empid then you can join the table with profile table. where you can use concatenate function on empid but you might need casting as well because in don't know your data type
chetan tembhre13y ago
Try this

SELECT E.EmployeeID,ISNULL(SUM(ES.Amount),0) AS Amt FROM Employee E
LEFT OUTER JOIN EmployeeSal ES ON E.EmployeeID=ES.EmployeeID
GROUP BY E.EmployeeID