SHARE
TWEET

Untitled

a guest Sep 22nd, 2019 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create procedure displayRental
  2. (@rentID as int)
  3. as
  4. begin
  5.     select Film.title, Rent.rentDate, Receipt.receivedDate, quantity, price, amount
  6.     from Rent, RentFilm, Film, ReceiptFilm, Receipt
  7.     where Rent.ID = RentFilm.rentID and RentFilm.filmID = film.ID
  8.     and Receipt.ID = ReceiptFilm.receiptID and ReceiptFilm.rentID = Rent.ID and ReceiptFilm.filmID = Film.ID
  9.     and Rent.ID = @rentID
  10. end;
  11. go
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top