PASTE-IT!

delimiter //
create procedure get_invoice_price_info(i_invoice_id INT)
begin
	select 		sum(ii_amount * ii_price) as bruto_price
	from 		invoices
	inner join	invoice_items
			on	ii_invoiceid = i_id
			and	i_id = i_invoice_id;
end //
delimiter ;