Sql query

[chantigadu]

hi all,
i need a query from which i need three columns from one table and count of that particular id from another table.

example
firstname, lastname from emp table
and count from dept table where empid from emp table

in single query



thankyou for doing this help


thanks

[camel]

SELECT  FirstName, LastName, COUNT(D.EmpID) 
FROM     Employees E
JOIN       Department D
        ON E.EmpID = D.EmpID
GROUP BY FirstName, LastName