SQL SELECT 连接列别名

Question

预先感谢您的帮助:

[People]表有两列:

• 人员ID
• 人名

[Marriages]表有三列:

• 婚姻 ID
• PersonIDa
• PersonIDb

我想选择以下列:

• 婚姻 ID
• PersonName(用于 personIDa)
• PersonName(用于 personIDb)

我想我需要使用SELECT带有 JOIN 的声明，但我不确定如何为每个 PersonName 分配唯一的别名。这是我到目前为止所拥有的(不起作用):

SELECT 
    [Marriages].[MarriageID], 
    [People].[PersonName] AS aName, 
    [People].[PersonName] AS bName  
FROM 
    [Marriages]  
JOIN 
    [People] ON [Marriages].[PersonIDa] = [People].[PersonID]  
JOIN 
    [People] ON [Marriages].[PersonIDb] = [People].[PersonID]  

再次感谢...

Answer 1

这符合您想要实现的目标吗？

SELECT m.[MarriageID], peopleA.[PersonName] AS aName, peopleB.[PersonName] AS bName  
FROM [Marriages]  M
JOIN [People] peopleA ON m.[PersonIDa] = peopleA.[PersonID]  
JOIN [People] peopleB ON m.[PersonIDb] = peopleB.[PersonID]