mysql根据字段条件删除重复数据

DELETE t1 FROM table1 t1
INNER JOIN table2 t2 
WHERE t1.create_time>t2.create_time AND t1.three_id=t2.three_id AND t1.data_source='xxx' AND t2.data_source='xxx';