Last 10 Posts - Please help

[uasound]

I've searched the forums hundred times and didn't find the hack that would do this

I needd to show last 10 threads with the latest posts.

I have this SQL

SELECT DISTINCT thread.threadid, 
post.postid, post.username, thread.title FROM post, thread WHERE thread.threadid = post.threadid ORDER BY post.dateline DESC LIMIT 10

But it will repeat the threads and the list will show same thread several times.

How do I make this work?

Thanks, appreciate your help!