Skip to content

Instantly share code, notes, and snippets.

@cflove

cflove/class-sql-temp

Last active August 29, 2015 14:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cflove/0cccddf1244c2c63a770 to your computer and use it in GitHub Desktop.
Save cflove/0cccddf1244c2c63a770 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
class-sql-temp
select EmailAddress from [Person].[EmailAddress]
where [BusinessEntityID] =
(
SELECT [BusinessEntityID]
FROM [Person].[Person]
where FirstName = 'Ken'
and LastName = 'Kwok'
)
----------------------------------------
select EmailAddress from [Person].[EmailAddress]
where
[BusinessEntityID] in
(
SELECT [BusinessEntityID]
FROM [Person].[Person]
where FirstName = 'Ken'
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment