sql - SQL Server多个左联接，一对多

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