Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select Aluno.nome, Aluno.cpf, Aluno.idade, Aluno.sexo, Disciplina.nome, Matricula.situacao, YEAR(Matricula.data) from Matricula
- JOIN Aluno ON (Matricula.idAluno = Aluno.idaluno)
- JOIN Disciplina ON (Matricula.iddisciplina = Disciplina.iddisciplina)
- Where Disciplina.nome = 'Administração' and YEAR(Matricula.data) = '2017'
Add Comment
Please, Sign In to add comment