如何把红框的内容作为参数
b.shopcode='${参数名称}'
on ${参数名称}=b.shopcode
用子查询,如果括号内返回多个值=改为in
select * from 表1 where shopcode=(select JB1 from 表2 where 字段=xx)
on a.JB1 = b.shopcode and a.JB1 = '${jb1}'