>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