select a.id, a.name, (selectlistagg(b.name, ',') withingroup(orderby b.id) from t_sm_line b where a.exc_line like b.id||',%'or a.exc_line like'%,'||b.id||',%' or a.exc_line like'%,'||b.id or a.exc_line = cast(a.id asvarchar(10)) orinstr(b.id,a.exc_line) >0) exc_line from t_sm_line a where a.exc_line isnotnull