Skip to content

Instantly share code, notes, and snippets.

@thiagoloureiro
Created October 20, 2017 02:35
Show Gist options
  • Save thiagoloureiro/5842e5283ae7ca5b724ce6a338e351ad to your computer and use it in GitHub Desktop.
Save thiagoloureiro/5842e5283ae7ca5b724ce6a338e351ad to your computer and use it in GitHub Desktop.
select
C.[Id], C.[Name], C.[Email], C.[Phone],
A.CustomerId, A.Street, A.City, A.Country, A.ZIPCode
from customer C inner join [Address] A on A.CustomerId = C.Id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment