insert into uf_ITMessage_Table_dt1
(mainid,
FCapitalgroupid,FCapitalBM,FCapitalName,FCapitalGuige,FCapitalDeviceNo)
select uf_ITMessage_Table.id,
capitalgroupid,mark,name,capitalspec,DeviceNumber
from cptcapital,uf_ITMessage_Table
where resourceid=FApplyUserId and
stateid=2 and
(mark LIKE 'IT%')