How can I select multiple columns from a subquery (in SQL Server) that should have one record (selec

I Know I can select a column from a subquery using this syntax: SELECT A.SalesOrderID, A.OrderDate, ( SELECT TOP 1 B.Foo FROM B WHERE A.SalesOrderID = B.SalesOrderID ... ... Here's generally how to select multiple columns from a subquery: ...

stackoverflow.com