title: SQL Server Multiple LEFT JOIN, one-to-many
body: <p>I am looking for a way to perform multiple joins from one source table to more than one table. Similar to the following:</p>
  
  <pre><code>SELECT a.NAME, b.address, c.phone
  FROM tblname a
  LEFT JOIN tbladdress b ON a.nid = b.nid
  </code></pre>
  
  <p>I also want to perform a left join on the Telephone table <code>tblPhone</code> at the same time:</p>
  
  <pre><code>tblname a left join tblPhone c on a.PID = c.PID
  </code></pre>
  
  <p>Try as I might I can't see how to put this into one query.</p>