Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP PROCEDURE faturasCliente;
- DELIMITER $$
- CREATE PROCEDURE faturasCliente(IN nomeCliente VARCHAR(45), IN dataInicio DATE ,IN dataFim DATE)
- BEGIN
- SELECT F.data, F.nome_Cliente, F.valor, F.Produtos
- FROM Pedido AS P
- INNER JOIN Cliente AS C
- ON P.Cliente = C.Nr_Contribuinte
- INNER JOIN Fatura AS F
- ON Cliente = F.id_cliente
- WHERE (F.nome_Cliente = nomeCliente && F.data >= dataInicio && F.data <= data Fim);
- END $$
- CALL faturasCliente ('Jaime Leite','2018-3-2','2018-5-25');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement