SQL Server 多个 LEFT JOIN，一对多

Question

我正在寻找一种方法来执行从一个源表到多个表的多个联接。类似于以下内容：

SELECT a.NAME, b.address, c.phone
FROM tblname a
LEFT JOIN tbladdress b ON a.nid = b.nid

我还想同时在电话表 tblPhone 上执行左连接：

tblname a left join tblPhone c on a.PID = c.PID

尽我所能尝试，但我不知道如何将其放入一个查询中。

Answer 1

您可以根据需要多次重复 JOIN 子句，例如：

SELECT a.NAME
    ,b.address
    ,c.phone
FROM tblname a
LEFT JOIN tbladdress b ON a.nid = b.nid
LEFT JOIN tblPhone c ON a.PID = c.PID

Answer 2

SELECT a.name, b.address, c.phone 
FROM tblname a 
left join tbladdress b on a.nid = b.nid
left join tblPhone c on a.PID = c.PID;

Answer 3

SELECT a.name, b.address, c.phone 
FROM (tblname a 
  left join tbladdress b on a.nid = b.nid) c 
left join tblPhone d on c.PID=d.PID