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
SQL 将查询出的表当做 value 插入到表中
最新推荐文章于 2023-02-17 17:15:22 发布