Skip to content

Instantly share code, notes, and snippets.

@hoganlong

hoganlong/example of join.sql

Last active March 3, 2017 21:22
Show Gist options
  • Save hoganlong/b5e3dec946e1f9d82910adfeafdae518 to your computer and use it in GitHub Desktop.
Save hoganlong/b5e3dec946e1f9d82910adfeafdae518 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
example of join.sql
SELECT *
FROM tableNm
WHERE circleNm IN ('test1', 'test2', 'test3')
-- is the same as
SELECT *
FROM tableNm
JOIN (
VALUES(
('test1'),
('test2'),
('test3')
)
) AS D(X) ON tableNm.circleNm = D.X
@hoganlong
Copy link
Author

Created for http://stackoverflow.com/questions/42586368/how-to-use-the-in-operator-in-a-where-clause-with-azure-mobile-apps-js-client?noredirect=1#comment72305162_42586368

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment