Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW compradores AS
- SELECT
- c.nome AS 'Cliente',
- p.nome AS 'Produto'
- FROM cliente c
- JOIN venda v ON v.id_cliente=c.id_cliente
- JOIN item_venda iv ON v.id_venda=iv.id_venda
- JOIN produto p ON p.id_produto=iv.id_produto
- WHERE v.data BETWEEN '2018-01-01' AND '2019-01-01';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement