I have a problem with the following query
select tbl_employee.E_Name,sum(tbl_Salary.Amt),tbl_Dpt.DeptName from tbl_employee inner join tbl_Salary on tbl_employee.eid = tbl_Salary.eid inner join tbl_Dpt on tbl_Salary.eid = tbl_Dpt.eid where tbl_employee.eid ='E101'
When the query is executed,the following error is displayed
"Column ' tbl_employee.E_Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."
I have tried it using group by having clause,but same error is displaying.
Any one please help me to figure out the problem.
Thanks In advance