34,590
社区成员
发帖
与我相关
我的任务
分享
USE tempdb
GO
IF OBJECT_ID('a') IS NOT NULL DROP TABLE a
IF OBJECT_ID('b') IS NOT NULL DROP TABLE b
GO
CREATE TABLE a(aName NVARCHAR(20),aNum VARCHAR(20))
CREATE TABLE b(bNum VARCHAR(20),tel INT)
INSERT INTO a
SELECT '张三','541'
UNION ALL SELECT '李四','611'
UNION ALL SELECT '王3','368'
INSERT INTO b
SELECT '36541','275680'
UNION ALL SELECT '36611','275877'
UNION ALL SELECT '36368','275411'
SELECT
a.aName
,a.aNum
,b.tel
FROM a INNER JOIN b ON a.aNum = RIGHT(b.bNum,3)
/*
aName aNum tel
张三 541 275680
李四 611 275877
王3 368 275411
*/