Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- e.EmprestimoID,
- u.Nome AS Nome_Usuario,
- l.Titulo AS Titulo_Livro,
- e.DataEmprestimo,
- e.DataDevolucao
- FROM
- Emprestimos e
- INNER JOIN
- Usuarios u ON e.UsuarioID = u.UsuarioID
- INNER JOIN
- Livros l ON e.LivroID = l.LivroID
- WHERE
- e.DataDevolucao > CURRENT_DATE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement