create procedure displayRental
(@rentID as int)
as
begin
	select Film.title, Rent.rentDate, Receipt.receivedDate, quantity, price, amount
	from Rent, RentFilm, Film, ReceiptFilm, Receipt
	where Rent.ID = RentFilm.rentID and RentFilm.filmID = film.ID
	and Receipt.ID = ReceiptFilm.receiptID and ReceiptFilm.rentID = Rent.ID and ReceiptFilm.filmID = Film.ID
	and Rent.ID = @rentID
end;
go