INNER JOIN WHERE |
DELETE FROM dbo_ACC_EVALUATION WHERE(dbo_ACC_EVALUATION.ID in (SELECT dbo_ACC_EVALUATION.ID FROM dbo_ACC_EVALUATION INNER JOIN ACC_EVALUATION ON (dbo_ACC_EVALUATION.EV_CASE_NUMBER = ACC_EVALUATION.EV_CASE_NUMBER AND dbo_ACC_EVALUATION.EV_MOPI = ACC_EVALUATION.EV_MOPI) WHERE(ACC_EVALUATION.RECORD_VERSION=-1)))
https://www.sql.ru/forum/1311556/udalit-zapisi-cherez-inner-join-s-where
