Last thread

[filburt1]

What query returns the forumid,threadid,and title for the most recent thread in each forum?

1. Yes, I looked at the code for TECK's hack
2. Yes, I tried this:
[sql]
SELECT t.title AS title, t.threadid AS threadid, f.forumid AS forumid
FROM thread t, forum f
WHERE t.forumid = f.forumid
GROUP BY f.forumid
ORDER BY dateline DESC
[/sql]
(it always returned the oldest one, not the most recent one)