Another query problem - what function?

[Fred Bassett]

For example, a database with three tables:
EMPLOYEE(employee#, empName, empAddress, empTel)
EMPLOYEE_ON_PROJECT(employee#, project#)
PROJECT(project#, projectStartDate, projectEndDate)

What sort of query would i have to run (or SQL would I have to type) to
return something like "A list of employee names for all of the employees
that are assigned to more than 2 projects (In the EMPLOYEE_ON_PROJECT)"?
I've been toying with 'COUNT' but don't think that's the right one...

I'm just using this database as an example, at the least I would just like
to know what function I would have to use to get the results that I need.
Im pretty stumped!

Thanks, Fred

[pietlinden]

sounds like right out of Elmasri's textbook! Wow.

Why not use the query builder?

Off the top of my head....

SELECT Employee.empName, Count(WorksOn.ProjectNo)
FROM Employee INNER JOIN WorksOn ON Employee.EmpNo=WorksOn.EmpNo
GROUP BY Employee.EmployeeNo
HAVING COUNT(WorksOn.ProjectNo)>1;

[Fred Bassett]

The example was something i'd done at uni, designing the database but not
doing any queries. It was the first thing that came to mind!

It works perfect for what i'm trying to do, so a really big thank you!

<pi********@hotmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

sounds like right out of Elmasri's textbook! Wow.

Why not use the query builder?

Off the top of my head....

SELECT Employee.empName, Count(WorksOn.ProjectNo)
FROM Employee INNER JOIN WorksOn ON Employee.EmpNo=WorksOn.EmpNo
GROUP BY Employee.EmployeeNo
HAVING COUNT(WorksOn.ProjectNo)>1;