sql - 部分字符串匹配 SQL - 内连接

Question

尝试在此处进行部分字符串匹配，但 LIKE 运算符出现问题。我确定它的语法，但我看不到它

SELECT Name
FROM Table1 a
INNER JOIN Table2 b ON a.Name = b.FullName LIKE '%' + a.Name + '%'

执行此操作时收到错误消息

Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'LIKE'.

Answer 1

尝试这个

SELECT distinct Name, FullName
FROM Table1 a
INNER JOIN Table2 b ON (b.FullName LIKE '%' + a.Name + '%' OR a.Name like '%'+b.FullName+'%')