[SOLVED] Need to get most recent row on an inner join mysql query based on date

[s0c0]

Here is my current query:

 

SELECT tbl1.id, tbl1.username, tbl1.status, tbl1.joined, tbl2.timeDate, tbl1.directory FROM tbl1, tbl2 WHERE tbl1.id = tbl2.users_id GROUP BY tbl1.id

 

This returns their oldest ie first login.  I use this for analytics on the backend to determine user activity.  So I would like a query that instead that returns the most recent tbl2.timeDate

 

And ideas?  Thanks in advanced.

[teng84]

add order by clause

[s0c0]

ORDER BY timeDate DESC

 

resolves issue, thanks, I swear I tried that but then again SQL is not a strong point for me, appreciated much teng84