这对我有用:
DECLARE @Table1 TABLE (XName VARCHAR(200))
DECLARE @Table2 TABLE (ZName VARCHAR(200))
INSERT
INTO @Table1
VALUES ('123456')
INSERT
INTO @Table2
VALUES ('ABC-123456')
SELECT *
FROM @Table1
LEFT JOIN
@Table2
ON ZName = 'ABC-' + XName
---
123456 ABC-123456
您能否发布表的定义和收到的错误消息?