query problem

donan · #1 (**permalink**) 11-29-11, 21:56

Well hi there

I have this piece of query

Code:

SELECT EmployeeID, count(EmployeeID) As Count
FROM Projects
Group By EmployeeID;

Briefly, the above query outputs a table in which the ID's of employees are displayed along with the amount of projects they are working on

what I want to do is:

add another line(s) in the query so it adds a column from a different table (in this case, I want the employee's full name to be shown next to the employee id and project amount, but without creating that column in the 'Projects' table - 'employee name' exists in 'employee' table)

what I tried is:

Code:

SELECT EmployeeID, count(EmployeeID) As Count
FROM Projects
AND SELECT EmployeeName From Employee
Group By EmployeeID;

But obviously mysql doesnt accept this kind of queries

I hope you can help me

Thanks in advance

r937 · #2 (**permalink**) 11-29-11, 22:30

what you're looking for is called a join

Code:

SELECT Projects.EmployeeID
     , Employee.EmployeeName
     , COUNT(*) As Count
  FROM Projects
INNER
  JOIN Employee
    ON Employee.EmployeeID = Projects.EmployeeID
GROUP 
    BY Projects.EmployeeID;

donan · #3 (**permalink**) 11-30-11, 07:04

thank you!!

Internet Services

Web Development

Digital Marketing

Consumer Tech