SQL 将查询出的表当做 value 插入到表中

?

insert into Print (printChannelStyleId,TemplateResourceID,CreateDate)

select a.id, b.id,getdate() from PrintStyle as a,Template as b where  a.catalogId in (27,28,29)

and b.BindType=a.styleCode