只要你数据库里面也是编码就行

with tablea as(

SELECT '1' [CODE],'张三' [NAME_]

UNION ALL

SELECT '2' [CODE],'李四' [NAME_]

UNION ALL

SELECT '3' [CODE],'王五' [NAME_]

UNION ALL

SELECT '4' [CODE],'赵六' [NAME_]

UNION ALL

SELECT '5' [CODE],'张七' [NAME_]

UNION ALL

SELECT '6' [CODE],'王八' [NAME_]

),

TABLEB AS (

SELECT '1' [CODE],10 SL

UNION ALL

SELECT '1' [CODE],10 SL

UNION ALL

SELECT '2' [CODE],10 SL

UNION ALL

SELECT '3' [CODE],10 SL

UNION ALL

SELECT '4' [CODE],10 SL

UNION ALL

SELECT '5' [CODE],10 SL

UNION ALL

SELECT '6' [CODE],10 SL

UNION ALL

SELECT '1' [CODE],10 SL

UNION ALL

SELECT '2' [CODE],10 SL

UNION ALL

SELECT '3' [CODE],10 SL

UNION ALL

SELECT '4' [CODE],10 SL

UNION ALL

SELECT '5' [CODE],10 SL

UNION ALL

SELECT '6' [CODE],10 SL

)

SELECT * FROM TABLEB WHERE EXISTS(SELECT * FROM TABLEA WHERE TABLEA.CODE=TABLEB.CODE AND TABLEA.NAME_ LIKE '%张%')

万一模糊出来有多个。怎么弄？？

只会按照你的实际值去查询