22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT a.[LoginName]
, b.[LoginName]
, c.[LoginName]
FROM [Users] AS a
LEFT JOIN [Users] AS b ON b.[UserID]=a.[FatherUserID]
LEFT JOIN [Users] AS c ON c.[UserID]=b.[FatherUserID]
SELECT a.[LoginName]
, b.[LoginName]
, c.[LoginName]
FROM [Users] AS a
INNER JOIN [Users] AS b ON b.[UserID]=a.[FatherUserID]
INNER JOIN [Users] AS c ON c.[UserID]=b.[FatherUserID]