Hi everyone,
I have three tables, set up like this,
Auctions:
Auction ID, Winner ID # (a Customer ID, as shown below), Price
Bids:
Auction ID, Customer ID, Price
Customers:
Customer ID, Name
I need to find a query that does this functionality:
For each auction (entry in the Auctions table)...