Hi
I am trying to make a qurey for combining two tables using group by clause
tables are-
table 1-
department
deptid deptname
1 c
2 c++
3
java
employee
empid empsal deptid
1 1000 1
2 2000 2
3 3000 3
4 1000 1
5 2000 2
6 3000 3
7 1000 1
8 2000 2
9 3000 3
10 1000 1
now the query requires to make another table having two columns
deptname totalsal
c 4000
c++ 6000
java 9000
i'v tried a lot but not getting how to make this query. the query i made is
SELECT Department.DeptId,SUM(Employee.EmpSal) as TotalSal
FROM Department, Employee
GROUP BY Department.DeptId
but it is showing wrong result.
please help