Insert Into t1(....) from ()INSERT INTO archivetitles
(title_id, title, type, pub_id)
SELECT title_id, title, type, pub_id
FROM titles
WHERE (pub_id = '0766')
(title_id, title, type, pub_id)
SELECT title_id, title, type, pub_id
FROM titles
WHERE (pub_id = '0766')
如果你用自增的就没问题了(设计表,将序号:标识 改成是)
你两个表序号好象没有实际用处