SELECT DISTINCT cperiodo ; FROM plhpl ; INTO CURSOR PeriodosEnPlhpl * There was a different FROM table that was queried here, but I don't have the original code. SELECT * ; FROM (lcTablaHin????) ; WHERE cperiodo NOT IN (SELECT cperiodo FROM PeriodosEnPlhpl) ; INTO TABLE (lcTablaHin)This is what I ended up doing:
SELECT DISTINCT cperiodo ; FROM plhpl ; INTO CURSOR PeriodosEnPlhpl SCAN SELECT (lcTablaHin) DELETE ALL FOR cPeriodo = PeriodosEnPlhpl.cPeriodo ENDSCAN SELECT (lcTablaHin) PACKThank you very much. Best regards.
>>SELECT * ; >> FROM Table1 ; >> WHERE FieldX NOT IN (SELECT FieldX FROM Table2) ; >> INTO TABLE (lcTable3Name) >>>>