数据刷表

规格型号

合并成一个字段 规格@型号

数据库选择AIS20230131214054

select a.FMATERIALID,FNUMBER, F_QINL_OQGG 规格 ,FSPECIFICATION 规格型号,FSPECIFICATIONGG 规格废弃 ,F_QINL_SPECIFICATION 型号
from t_bd_material  a
left join T_BD_MATERIAL_L b 
on a.FMASTERID = b.FMATERIALID

F_QINL_OQGG + @ + F_QINL_SPECIFICATION = FSPECIFICATION
其中 FSPECIFICATIONGG 自定义（已经废弃）

update T_BD_MATERIAL_L
set FSPECIFICATION = F_QINL_SPECIFICATION+ '@' + F_QINL_OQGG
where FMATERIALID = 162518

select 
	a.FMATERIALID,FNUMBER 物料代码  ,F_QINL_SPECIFICATION 型号
	, b.F_QINL_OQGG 规格 ,b.FSPECIFICATION 规格型号,   F_QINL_SPECIFICATION + '@' +  F_QINL_OQGG as 拼接
	,FSPECIFICATIONGG 规格废弃
from t_bd_material  a
	left join T_BD_MATERIAL_L b on a.FMASTERID = b.FMATERIALID
where
	FNUMBER='5.01.17.0242' and
	FSPECIFICATION !=  F_QINL_SPECIFICATION + '@' +  F_QINL_OQGG