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
>