title: How can I select multiple columns from a subquery (in SQL Server) that should have one record (select top 1) for each record in the main query?
body: <p>I Know I can select a column from a subquery using this syntax:</p>
  
  <pre><code>SELECT A.SalesOrderID, A.OrderDate,
         (
         SELECT TOP 1 B.Foo
         FROM B
         WHERE A.SalesOrderID = B.SalesOrderID
         ) AS FooFromB
  FROM A
  WHERE A.Date BETWEEN '2000-1-4' AND '2010-1-4'
  </code></pre>
  
  <p>But what is the correct syntax to use multiple columns from a subquery (in my case a select top 1 subquery)? Thank you very much.</p>