Hi guys,

I'm trying to use a query using CROSS APPLY like this:

SELECT C.CustomerID, O.SalesOrderID, O.TotalDue FROM AdventureWorks.Sales.Customer AS C CROSS APPLY AdventureWorks.dbo.fn_GetTopOrders(C.CustomerID, 3) AS O ORDER BY CustomerID ASC, TotalDue DESC

Is there a way how I can embed this query in a predicate?

By the way, I'm using the adapter scenario.

Thanks in advance,

Gerben Vermeulen

Only with a custom relationpredicate bucket class which has its own RelationCollection derived class in where you override the ToQueryText, which forms the FROM clause. It's tricky though, basicly what I'd do is simply formulate a query in a RetrievalQuery object and use that to fetch a projection