This project has moved. For the latest updates, please go here.
1

Closed

Support subselects in ON clause if join type is FULL OUTER

description

Currently, NQuery does not support subqueries in an ON clause of a join if the join type is FULL OUTER (throws InternalError). For example, the follwoing query cannot be executed:

SELECT  *
FROM    Territories t
            FULL JOIN EmployeeTerritories et ON et.TerritoryID = t.TerritoryID AND
                        EXISTS (
                            SELECT  *
                            FROM    Territories it
                            WHERE   it.TerritoryId = et.TerritoryId
                        )
Closed Oct 31, 2014 at 6:30 AM by terrajobst

comments