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