Does anyone know how to set up an Internal BAQ in Epicor and use Outer Apply or Cross Apply?
AFAIK, not possible. You have to use CTEs or subqueries. This is why I end up mostly using External BAQs to save on development time and query speed
Does anyone know how to set up an Internal BAQ in Epicor and use Outer Apply or Cross Apply?
AFAIK, not possible. You have to use CTEs or subqueries. This is why I end up mostly using External BAQs to save on development time and query speed