title: Combine two small Selects in one in SQL Server
body: <p>I am using the following nested Selects as part of a larger query. </p>
  
  <p>Is there a way that I can combine both of them in one so that I don't have to run two separate queries?</p>
  
  <pre><code>// ...
  R.requester,
  (
      SELECT      A.Email AS requesterEmail
      FROM        LogTable A
      WHERE       A.NTID = R.requester
      FOR XML PATH(''), ELEMENTS, TYPE
  ),
  R.approver,
  (
      SELECT      B.Email AS approverEmail
      FROM        LogTable B
      WHERE       B.NTID = R.approver
      FOR XML PATH(''), ELEMENTS, TYPE
  ),
  // ...
  </code></pre>