从一个数据库导入到另一个数据库语句

----PackingList表身表导入--------
USE DB_丢数据的帐套
INSERT INTO TF_LIST
SELECT * FROM DB_昨天备份的数据.DBO.TF_LIST A WHERE A.PK_NO NOT IN (SELECT PK_NO FROM MF_LIST)

USE DB_丢数据的帐套
INSERT INTO TF_LIST1
SELECT * FROM DB_昨天备份的数据.DBO.TF_LIST1 A WHERE A.PK_NO NOT IN (SELECT PK_NO FROM MF_LIST)

----PackingList表头表导入--------

USE DB_丢数据的帐套
INSERT INTO MF_LIST
SELECT * FROM DB_昨天备份的数据.DBO.MF_LIST A WHERE A.PK_NO NOT IN (SELECT PK_NO FROM MF_LIST)

USE DB_丢数据的帐套
INSERT INTO TF_LIST
SELECT A.* FROM DB_昨天备份的数据.DBO.TF_LIST A INNER JOIN MF_LIST B ON A.PK_NO=B.PK_NO WHERE B.PK_DD>='2008-10-27' AND B.PK_DD<='2008-10-31'