You have to rewrite your query. CROSS APPLY is currently not supported
by server and there's no direct (general) rewrite with other
operators. :(
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
-
Hi,
I find a situation that Firebird's generated code don't run because the
CROSS APPLY is used. The issue is generated because I need to create a
query inside the where clause. I'll show the code that runs and part of the
code that brings the issue,
ITENS_ENTRADA.**Where(w
=> (w.PRODUTOS.**ESTOQ