SELECT DISTINCT id FROM Task WHERE MainId = 12345 INTO CURSOR setId DELETE FROM Resource WHERE TaskId IN (SELECT id FROM setId) USE IN setId