SQL 在left join和inner join中使用Like模糊关联
select * from aaa a LEFT JOIN bbb b on b.field like '%'+a.field +'%'