Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- LivroID,
- Titulo
- FROM
- Livros
- WHERE
- LivroID NOT IN (SELECT LivroID FROM Emprestimos);
- CREATE OR REPLACE VIEW Livros_Disponiveis AS
- SELECT
- LivroID,
- Titulo
- FROM
- Livros
- WHERE
- LivroID NOT IN (SELECT LivroID FROM Emprestimos);
- SELECT * FROM Livros_Disponiveis;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement