Skip to content

Instantly share code, notes, and snippets.

@dclarke-modus

dclarke-modus/gist:1f4c90c1404660dfe2d0ce1805a3a6f9

Last active August 31, 2017 08:29
Show Gist options
  • Save dclarke-modus/1f4c90c1404660dfe2d0ce1805a3a6f9 to your computer and use it in GitHub Desktop.
Save dclarke-modus/1f4c90c1404660dfe2d0ce1805a3a6f9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Table Employee Table Department
id, name department id, alias
1, Anh Hoang 1 1, Accounts
2, Anh Hoang 1
3, Dean Clarke
@dclarke-modus
Copy link
Author

select Employee. name, Department.alias from Employee INNER JOIN Department on Employee.department = Department.id

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