Hi all.
I have 3 tables:(Im using Access)

USERS-
--userID
--userName
Messages-
--MessageID
--PostDate
--Title
--userid
Categories-
--CateId
--name
--lastMessageId

now, I want to select all the categories names, the postdate and title of the message with the LastMessageId of the category, in addition I want to select the username by the userid of the message which was selected by the lastmessageid of the category.

Hope you understand, thanks!

SELECT CATEGORIES.name, MESSAGES.PostDate, MESSAGES.Title, USERS.userName
FROM USERS INNER JOIN (MESSAGES INNER JOIN CATEGORIES ON MESSAGES.MessageID = CATEGORIES.lastMessageID) ON USERS.userID = MESSAGES.userID;