SELECT Person.lname, Person.totassignhrs, SUM(Pinfo.totcomphrs),;
>>  Person.failcmpldate;
>> FROM  workprog!person INNER JOIN workprog!pinfo ;
>>   ON  Person.personid = Pinfo.personid;
>> WHERE NOT (Person.compstatus == "COMPLETE");
>   <b>GROUP BY Person.personID ;</b>
>>  <b>HAVING</b> SUM(Pinfo.totcomphrs) = Person.totassignhrs
>>