Advertisement
Rafael_Yuki

Untitled

Feb 29th, 2024
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     e.EmprestimoID,
  3.     u.Nome AS Nome_Usuario,
  4.     l.Titulo AS Titulo_Livro,
  5.     e.DataEmprestimo,
  6.     e.DataDevolucao
  7. FROM
  8.     Emprestimos e
  9. INNER JOIN
  10.     Usuarios u ON e.UsuarioID = u.UsuarioID
  11. INNER JOIN
  12.     Livros l ON e.LivroID = l.LivroID
  13. WHERE
  14.     e.DataDevolucao > CURRENT_DATE;
  15.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement