USE T202425

SELECT * INTO Tmp_RETURN_GOODS_IMAGES_DETAIL FROM (SELECT DISTINCT * FROM RETURN_GOODS_IMAGES_DETAIL) AS T1
SELECT * INTO Tmp_RETURN_GOODS_ADDLESS_DETAIL FROM (SELECT DISTINCT * FROM RETURN_GOODS_ADDLESS_DETAIL) AS T1
SELECT * INTO Tmp_RETURN_GOODS_ITEM_DETAIL FROM (SELECT DISTINCT * FROM RETURN_GOODS_ITEM_DETAIL) AS T1
SELECT * INTO Tmp_RETURN_GOODS_DETAIL FROM (SELECT DISTINCT * FROM RETURN_GOODS_DETAIL) AS T1
        
DELETE FROM RETURN_GOODS_IMAGES_DETAIL
DELETE FROM RETURN_GOODS_ADDLESS_DETAIL
DELETE FROM RETURN_GOODS_ITEM_DETAIL
DELETE FROM RETURN_GOODS_DETAIL

INSERT INTO RETURN_GOODS_IMAGES_DETAIL SELECT * FROM Tmp_RETURN_GOODS_IMAGES_DETAIL
INSERT INTO RETURN_GOODS_ADDLESS_DETAIL SELECT * FROM Tmp_RETURN_GOODS_ADDLESS_DETAIL
INSERT INTO RETURN_GOODS_ITEM_DETAIL SELECT * FROM Tmp_RETURN_GOODS_ITEM_DETAIL
INSERT INTO RETURN_GOODS_DETAIL SELECT * FROM Tmp_RETURN_GOODS_DETAIL
        
DROP TABLE Tmp_RETURN_GOODS_IMAGES_DETAIL
DROP TABLE Tmp_RETURN_GOODS_ADDLESS_DETAIL
DROP TABLE Tmp_RETURN_GOODS_ITEM_DETAIL
DROP TABLE Tmp_RETURN_GOODS_DETAIL