MSSQL Join Probleme

Zitat

In SQL Server 2005 and above, you could just replace INNER JOIN with CROSS APPLY:

Code: SQL

SELECT  Orders.OrderNumber, LineItems2.Quantity, LineItems2.Description 
FROM    Orders 
CROSS APPLY         (
         SELECT  TOP 1 LineItems.Quantity, LineItems.Description
         FROM    LineItems
         WHERE   LineItems.OrderID = Orders.OrderID
         ) LineItems2