DELETE FROM claim_1
WHERE ClaimId IN
(SELECT claimid FROM claim t
where t.AcceptTime <'2018-01-01')
DELETE FROM accidentvehicle
WHERE ClaimId IN
(SELECT claimid FROM claim t
where t.AcceptTime < '2018-01-01' )
DELETE FROM claim_1 where AcceptTime <'2017-01-01' ;