Skip to content

Instantly share code, notes, and snippets.

@xavierzwirtz
Created April 19, 2015 03:44
Show Gist options
  • Save xavierzwirtz/ea355857671f02a0f878 to your computer and use it in GitHub Desktop.
Save xavierzwirtz/ea355857671f02a0f878 to your computer and use it in GitHub Desktop.
query {
for p in queryable<Person>() do
where(query {
for e in queryable<Employee>() do
where(e.DepartmentId = Some(!departmentId))
select e.PersonId
contains p.PersonId
})
select p
}
SELECT T.PersonId
,T.PersonName
,T.JobKind
,T.VersionNo
FROM Person AS T
WHERE (
T.PersonId IN (
SELECT T2.PersonId
FROM Employee AS T2
WHERE (T2.DepartmentId = @p1)
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment