Maria

Maria

  • NA
  • 64
  • 0

Query Help...Need to find last user

Dec 28 2008 5:46 PM

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


Answers (3)