use t25r001 INSERT INTO ACCOUNT_TYPES SELECT * FROM COMMON.DBO.ACCOUNT_TYPES WHERE ACCTYPES NOT IN (SELECT ACCTYPES FROM T25R001.DBO.ACCOUNT_TYPES) INSERT INTO COMMON.DBO.ACCOUNT_TYPES SELECT * FROM T25R001.DBO.ACCOUNT_TYPES WHERE ACCTYPES NOT IN (SELECT ACCTYPES FROM COMMON.DBO.ACCOUNT_TYPES)