SQLserver:一个字段多个id,如何关联

SELECT
b.id,
a.param_data--对应b表id,可多选

from
AAAA a
left join  BBBB b
on   a.param_data like '%'+CAST(b.id AS VARCHAR(255))+'%'
order by a.create_time desc

结果如下

PS:

Mysql 字段存储多个ID关联查询（GROUP_CONCAT和FIND_IN_SET函数用法）_mysql 字段关联新增的几个id-优快云博客