Delete FROM HC_RESUME_SUBFUNCTION Where ResumeID IN (Select RID FROM HC_RESUME_BANK Where UniqueNo IN (37968,37964,37952,37944,37941,37774,37773,37757,37752,37748,37742,37738,37730,37722,37717,37711,37643,37636,37615,37603,37602,37596,37590,37589,37587,37583,37579,37576,37562,37558,37545,37542,37538,37535,37533,37530,37528,37523,37517,37515,37511,37501,37499,37411,37408,37406,37401,37399,37397,37394,37391,37384,37381,37378,37374,37372,37361,37359,37357,37353,37350,24562,24682,25713,35293,35483,36544,36910,36914,36917,36918,36923,36931,36935,36939,36941,36943,36950,36958,36963,36970,36980,36984,36994,36995,36998,37003,37019,37025,37029,37033,37042,37046,37063,37071,37082,37084,37086,37089,37095,37097,37101,37112,37122,37124,37125,37131,37138,37150,37166,37170,37181,37183,37187,37190,37194,37198,37199,37205,37208,37212,37216,37218,37219,37221,37229,37236,37241,37243,37246,37247,37249,37252,37260,37262,37265,37267,37269,37273,37275,37278,37280,37285,37289,37291,37292,37295,37297,37300,37301,37302,37304,37310,37311,37316,37317,37321,37325,37326,37327,37331,37335,37338,37343,37345))

Insert Into HC_RESUME_SUBFUNCTION
Select b.RID ,a.RID
FROM HC_RESUME_BANK a,HCM_SUBFUNCTION_AREA b
Where UniqueNo IN (37968,37964,37952,37944,37941,37774,37773,37757,37752,37748,37742,37738,37730,37722,37717,37711,37643,37636,37615,37603,37602,37596,37590,37589,37587,37583,37579,37576,37562,37558,37545,37542,37538,37535,37533,37530,37528,37523,37517,37515,37511,37501,37499,37411,37408,37406,37401,37399,37397,37394,37391,37384,37381,37378,37374,37372,37361,37359,37357,37353,37350,24562,24682,25713,35293,35483,36544,36910,36914,36917,36918,36923,36931,36935,36939,36941,36943,36950,36958,36963,36970,36980,36984,36994,36995,36998,37003,37019,37025,37029,37033,37042,37046,37063,37071,37082,37084,37086,37089,37095,37097,37101,37112,37122,37124,37125,37131,37138,37150,37166,37170,37181,37183,37187,37190,37194,37198,37199,37205,37208,37212,37216,37218,37219,37221,37229,37236,37241,37243,37246,37247,37249,37252,37260,37262,37265,37267,37269,37273,37275,37278,37280,37285,37289,37291,37292,37295,37297,37300,37301,37302,37304,37310,37311,37316,37317,37321,37325,37326,37327,37331,37335,37338,37343,37345)
And b.RID =593