insert into 新表1
(DepartName,n_Title,createDate,n_Content,sfsh,ModuleID,n_Identifier)
select
'办公室' as DepartName,
Title as n_Title,
adddate as createDate,
Content as n_Content,
sfsh as sfsh,
'18' as ModuleID,
n_Identifier as n_Identifier
from 源表2 where 条件
新表需要数据 源表没有的 既可以 '办公室' as DepartName,