mysql - 通过映射表选择值。

Question

我有三个表senderTable、recieverTable和一个ma​​pTable。我正在尝试编写一个查询来获取 senderName 和 recieverName 的输出

发件人表

senderID
senderName

接收表

recieverID
recieverName

map 表

mappingID
senderID
recieverID

我有以下查询，该查询不起作用，因为我不知道如何将映射表合并到其中。

SELECT t_senderTable.nameFull AS "senderName", t_recieverTable.recieverName AS "recieverName" 
FROM ((dbo.t_senderTable AS t_senderTable
     INNER JOIN t_senderTable AS t_senderTable ON (t_senderTable.Kd = mapTable.senderID))
     INNER JOIN t_recieverTable AS t_recieverTabler ON (recieverTable.Id = mapTable.recieverID ))

有什么想法可以正确执行吗？谢谢

Answer 1

这是您要找的吗？

SELECT t_senderTable.nameFull AS "senderName"
     , t_recieverTable.recieverName AS "recieverName" 
  FROM dbo.t_senderTable AS t_senderTable
 INNER JOIN mapTable
    ON t_senderTable.Id = mapTable.senderID
 INNER JOIN t_recieverTable AS t_recieverTabler
    ON mapTable.recieverID = recieverTable.Id