Trying very basic steps after reading and still getting nowhere.
Here is my SQL view:
SELECT Customers.ContactLastName, Customers.PhoneNumber, Rentals.Rentals, Rentals.[Return Date], Rentals.Media, Rentals.[Due Date], Rentals.[Rental Date], Rentals.[Media Item Category], Media.GAMES, Media.Title, Media.DVD, Media.VHS, Categories.CategoriesID
FROM Media, (Customers INNER JOIN Rentals ON Customers.CustomerID = Rentals.CustomerID) INNER JOIN Categories ON Rentals.[Media Item Category] = Categories.[Media Item Category]
WHERE (((Rentals.[Return Date]) Is Null))
ORDER BY Customers.ContactLastName, Customers.PhoneNumber, Rentals.Rentals, Rentals.[Return Date], Rentals.Media, Rentals.[Due Date], Rentals.[Rental Date], Rentals.[Media Item Category];
I have records in each table. One record in the rentals table 'return date' is intentionaly blank however when I run the query nothing comes up. Shouldn't that one record appear? What did I do wrong?