Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support subselects in ON clause if join type is FULL OUTER #21

Open
terrajobst opened this issue Oct 31, 2014 · 1 comment
Open

Support subselects in ON clause if join type is FULL OUTER #21

terrajobst opened this issue Oct 31, 2014 · 1 comment

Comments

@terrajobst
Copy link
Owner

Ported from CodePlex

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 following 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
                        )
@dallmair
Copy link

Works fine in v.Next (results also look good to me).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants