This is the original:
SELECT top 1 tblAuthor.Username, tblAuthor.Author_ID, tblThread.Author_ID,tblThread.Topic_ID, tblThread.Thread_ID, tblThread.Message_date FROM tblAuthor, tblThread WHERE tblAuthor.Author_ID = tblThread.Author_ID AND tblThread.Topic_ID IN (SELECT top 1tblTopic.Topic_ID...