Query Help

[vloops]

I have a library database where users can borrow media from my inventory list. I am trying to query the database to find out the last user to borrow certain media. Rather than get the last user(s) to borrow the media I get a list of all the users to make a borrow transaction. I believe I am just leaving out something very simple. Please help.

This is my query:
SELECT Users.LastName,Users.UserID,InvTransactions.TransDate FROM InventoryData,InvTransactions,TransToUser,Users WHERE Users.UserID=TransToUser.UserID AND TransToUser.TransactID=InvTransactions.TransactID AND InventoryData.InventoryID=24

[davey23uk]

better ask you teacher for help

[LKBrwn_DBA]

HINT:

Try adding a condition to select the MAX(InvTransactions.TransDate) for that media.