INSERT INTO T202122.DBO.COMPANY_DETAIL SELECT * FROM T202021.DBO.COMPANY_DETAIL WHERE COMPCODE NOT IN (SELECT COMPCODE FROM T202122.DBO.COMPANY_DETAIL )