Help with 2 queries / Join problem

From: dwight0 <dwightrau_at_yahoo.com>
Date: 24 Jun 2004 14:59:48 -0700
Message-ID: <58b6c09c.0406241359.183b3882@posting.google.com>

I am having a problem with a query,
I am not sure if i would use a join or a subquery to complete this problem.
I have two queries, and i need to divide one by the other, but i cant seem to get any
type of join to work with them.
Here is the situation.
I have a projectDB table that has a list of different projects for each employee to work on.
Each project has an employee assigned to it. The start date is null until the employee starts to work on it. I want to find how many percent of all their projects that each employee is working on.
In other words:
I want to divide query A by query B to see how many percent of projects each employee is working on.

Query A count of projects that are being worked because they have a date per employee:

SELECT     employee, COUNT(employee) AS cnt
FROM         projectDB
GROUP BY employee, project_start_date
HAVING      (NOT (project_start_date IS NULL))  //notice the NOT


Query B: Total amount of project per employee:
SELECT     employee, COUNT(employee) AS cnt
FROM         projectDB

GROUP BY employee, project_start_date

Any ideas? Received on Thu Jun 24 2004 - 16:59:48 CDT