DELETE SCENE_MOUT FROM SCENE_MOUT [S] LEFT JOIN SCENE_MINP [S1] ON S.INP_NO = S1.INP_NO LEFT JOIN MATERIAL_STOCK_OUT [S2] ON S2.OUT_NO = S1.OUT_NO WHERE S2.LOTNO IS NULL 여기에 트랜잭션까지 같이 하면 BEGIN TRAN SELECT COUNT(*) FROM SCENE_MOUT [S] LEFT JOIN SCENE_MINP [S1] ON S.INP_NO = S1.INP_NO LEFT JOIN MATERIAL_STOCK_OUT [S2] ON S2.OUT_NO = S1.OUT_NO WHERE S2.L..