Advertisement
Guest User

Untitled

a guest
May 11th, 2019
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.30 KB | None | 0 0
  1. SELECT DISTINCT Movies.title  
  2. FROM Rentals  
  3.     INNER JOIN Customers ON Rentals.customerNum=Customers.customerNum
  4.     INNER JOIN Copies ON Rentals.barcode=Copies.barcode
  5.     INNER JOIN Movies ON Copies.movieNum=Movies.movieNum  
  6. WHERE Customers.givenName='Chad'  
  7. AND Customers.familyName='Black';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement