>>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) >>>>
>>SELECT DISTINCT cperiodo ; >> FROM plhpl ; >> INTO CURSOR PeriodosEnPlhpl >>SCAN >> SELECT (lcTablaHin) >> DELETE ALL FOR cPeriodo = PeriodosEnPlhpl.cPeriodo >>ENDSCAN >>SELECT (lcTablaHin) >>PACK >>>>
>SELECT DISTINCT cperiodo ; > FROM plhpl ; > INTO CURSOR PeriodosEnPlhpl >SCAN > SELECT (lcTablaHin) > DELETE ALL FOR cPeriodo = PeriodosEnPlhpl.cPeriodo >ENDSCAN >SELECT (lcTablaHin) >PACK >>
>SELECT (lcTablaHin) >DELETE FROM (ALIAS()) AS X WHERE EXISTS(SELECT * FROM plhpl WHERE cPeriodo=X.cPeriodo) >PACK >Thank you for the suggestion Fabio.