Skip to content

Instantly share code, notes, and snippets.

@jgc128
Created May 4, 2013 15:19
Show Gist options
  • Save jgc128/5517786 to your computer and use it in GitHub Desktop.
Save jgc128/5517786 to your computer and use it in GitHub Desktop.
SELECT
[Project2].[id] AS [id],
[Project2].[stimul] AS [stimul]
FROM ( SELECT
[Extent1].[id] AS [id],
[Extent1].[stimul] AS [stimul]
FROM [dbo].[stimuls] AS [Extent1]
WHERE EXISTS (SELECT
1 AS [C1]
FROM [dbo].[reactions] AS [Extent2]
WHERE ([Extent1].[id] = [Extent2].[stimul]) AND ([Extent2].[experiment] = @p__linq__0)
)
) AS [Project2]
ORDER BY [Project2].[stimul] ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment