22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT A.UserName,B.DepName,A.JobNumber FROM User AS A INNER JOIN Dep AS B
ON A.Dep = B.DepId where A.Name = '刘珠'
SELECT A.UserName ,
B.DepName ,
A.JobNumber
FROM [User] AS A
INNER JOIN Dep AS B ON CHARINDEX(RTRIM(A.Dep), B.DepId) > 0
WHERE A.Name = '刘珠'
SELECT A.UserName ,
B.DepName ,
A.JobNumber
FROM Dep AS B
LEFT JOIN [User] AS A ON A.Dep = B.DepId
WHERE A.Name = '刘珠'