select
a.TZ||' '||a.BZ 备注一
from
(
select distinct
bmba002 bomtx,
case when substr(bmba003,1,2) !='30' then '30'||substr(bmba003,3,10) else bmba003 end lh,
imecl005 tz,
bmbaud010 bz
from
bmba_t
left join bmce_t on bmce001 = bmba001 and bmce003 = bmba003 and bmce002 = bmba002 and bmbaent = bmceent and bmbasite = bmcesite
left join imecl_t on imecl003 = bmce010 and imeclent = bmceent
where bmba002 ='BO-1004-2' and bmba003 like '3%' and bmbasite = 'ALL' and bmbaud010 is not null and bmce010 is not null and bmbaud010 !='加0.25%爽滑剂'
) a想要的目的是最终结果把那三条记录拼接变成一条记录 最终变成 黄PP-4022 外喷砂/黄PP-4022 外喷砂/黄PP-4022 外喷砂