2020-02-16 标签:insert,tbl,select,tb,中加,多个,条件,实现,代码,如下,warehouse,wlbm,wlmc,ys,wlgg,sybm,wlfl,rtrim,b

实现代码如下：insert into warehouse(wlbm,wlmc,ys,wlgg,sybm,wlfl) select * from (select rtrim(b.bjbm) as bjbm,a.bjmc as wlmc, a.ys, a.clgg as wlgg,a.bm, (case