Skip to content

Instantly share code, notes, and snippets.

@fandrefh

fandrefh/joins_auladb.sql

Created December 11, 2020 00:37
Show Gist options
  • Save fandrefh/63e296572d3e3396ba0038ae3c9df77c to your computer and use it in GitHub Desktop.
Save fandrefh/63e296572d3e3396ba0038ae3c9df77c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
joins_auladb.sql
select m.id as matricula, a.nome as aluno, c.nome as curso, m.data_matricula as data_matricula
from matricula as m left join aluno as a on m.aluno_id = a.id
left join curso as c on m.curso_id = c.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment