USE T20G001 SELECT * FROM FIRM_ADDLESS_DETAIL ORDER BY FORMNAME,FORMSRNO,SRNO SELECT * INTO TMP_FIRM_ADDLESS_DETAIL FROM FIRM_ADDLESS_DETAIL INSERT INTO FIRM_ADDLESS_DETAIL SELECT DISTINCT * FROM TMP_FIRM_ADDLESS_DETAIL
USE T20G001 SELECT * FROM FIRM_ADDLESS_DETAIL ORDER BY FORMNAME,FORMSRNO,SRNO SELECT * INTO TMP_FIRM_ADDLESS_DETAIL FROM FIRM_ADDLESS_DETAIL INSERT INTO FIRM_ADDLESS_DETAIL SELECT DISTINCT * FROM TMP_FIRM_ADDLESS_DETAIL