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
--sb--