Simething like

SELECT * FROM prog_crsr ps ;
  WHERE NOT EXISTS ( ;
    SELECT * FROM task_hrs th  ;
     WHERE ps.WBS = th.sequence AND ps.HomeDepartmentNum = th.dept ;
       AND th.work_o = lcNum) ;
 INTO CURSOR hrs_crsr

>Hi,
>
>I am trying to do an "Inverse" SELECT - see the "NOT" in the next statement.
>
>This syntax is wrong, I know that.
>
>Does someone know the correct syntax?
>
>Thanks, J
>
>
>SELECT * FROM prog_crsr a NOT INNER JOIN task_hrs b ON ;
> (a.WBS = b.sequence AND a.HomeDepartmentNum = b.dept) ;
> WHERE b.work_o = lcNum INTO CURSOR hrs_crsr