L?KE
02-04-2009, 09:13 PM
This is for my year 11 GCSE ICT project, which I am drastically behind on, lol.
Well anyway mine for a DVD shop, and there is a rentals table which takes the ID of the customer who made the rental and the ID of the product that is being rented.
I have a query that picks up all rentals that are maked as not returned, and the return date was 3 or more days ago.
How would I go about using the results from this query to grab the Customer and Product details based on the results returned from this query (i.e. the Product ID, Customer ID for each overdue item).
Below is an example result for the overdue products query:
http://i158.photobucket.com/albums/t104/lukejs/lolbeans.png
So I want to get the details for the customer who's ID is 1 (in the above example)
Well anyway mine for a DVD shop, and there is a rentals table which takes the ID of the customer who made the rental and the ID of the product that is being rented.
I have a query that picks up all rentals that are maked as not returned, and the return date was 3 or more days ago.
How would I go about using the results from this query to grab the Customer and Product details based on the results returned from this query (i.e. the Product ID, Customer ID for each overdue item).
Below is an example result for the overdue products query:
http://i158.photobucket.com/albums/t104/lukejs/lolbeans.png
So I want to get the details for the customer who's ID is 1 (in the above example)