Hours Used Hours Alloted
19 | 36|104
-Original Message-
From: Jigal van Hemert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 03, 2004 9:05 AM
To: Mysql (E-mail)
Subject: Re: Problem with joins and query
- Original Message -
From
- Original Message -
From: "Luis Lebron" <[EMAIL PROTECTED]>
> Select M.Catid, sum(M.Hours) as allotedhours, sum(T.Hours) as usedHours
> >From Manhours as M, Tasks as T
> Where M.ProjectId=32
> AND T.ChargeNum=M.ChargeNum
> AND T.EmployeeID=M.EmployeeID
> AND T.Catid=M.Catid
> Group by M.C
