各位大神，求助个sql问题！表见图片

select tab_1.name,count(*) as count from tab_2
left join tab_2 on tab_2.fullname like concat('%', tab_1.name, '%')
group by name
上面是mysql的语法。 sql的字符串连接用的是+。你可以试一下，我没装sql，无法验证。

select t1.name,count(t1.name) as count
from tab_1 t1 left join tab_2 t2 on t2.fullname like '*' & t1.name & '*' group by t1.name
我用的access 大概语法是这样

select tab_1.name,count(*) as count from tab_1
left join tab_2 on tab_2.fullname like TRIM(concat('%', tab_1.name, '%'))group by name