- Original Message -
From: "Luis Lebron" <[EMAIL PROTECTED]>
> The data tables look like this:
>
> Manhours
> mid | ProjectId |ChargeNum | Catid | Hours | EmployeeId
>
> 1 | 32 |11 | 19 | 80 |200020
> 2 | 32 |11 | 19 | 24
> |23
>
>
> Tasks
> TaskID |ChargeNum |Catid |Em
I am having a problem with a query that joins the following tables. I want
to create a query that would tell me how many Manhours have been alloted for
a particular
project (32) by category and how many hours (from the Tasks table) have
actually been used for this project and category.
The data ta
