就类似于上面两个表组合出下面这个表。先谢过各位大神。

11

select a.xm as xm， a.tsm as tsm，b.sampnum as type4num，cast(b.sampnum as varchar) +cast(b.barcode as varchar) as type5num from 表1 as a，表2 as b where a.tsm=b.barcode and b.type=4 大小写自己注意

结果的第四个字段不用拼接的话，自己用一个case when判断一下