if first had a single thread message board and i used this query through php to get all messages and their posters from one database

SELECT * FROM message LEFT JOIN user ON user.uid = message.uid ORDER BY message.date ASC

this was working fine now i try to add multiple threads to this board. i am quite sure is should use this extra parameter somewhere

WHERE tid = $thread

but i can't seem to got this to work, what would be the correct query?

thanks in advance for any help