Welcome to the Treehouse Community
Looking to learn something new?
Using 2 Inner Joins at the same time?
How do I use 2 joins at once? I'm getting a syntax error (Missing Operator).
SELECT Rentals.RentalDate, Rentals.Due, Customers.lastname, Customers.firstname, Media.ItemTitle FROM Rentals INNER JOIN Customers ON Rentals.Customer = Customers.ID INNER JOIN Media ON Rentals.Media = Media.ItemTitle WHERE Date() > Rentals.Due;
Steven Parker216,083 Points
Just a wild guess.
Without seeing the challenge, I'm just wondering if that last join should be:
... INNER JOIN Media ON Rentals.Media = Media.ID ...
It would make sense if the Media table were constructed like the Customers table.