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

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

瀏覽:958
日期:2025-05-04
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: ......看更多