Complex join statement

[eluser]tchule[/eluser]
Hello,

I think you have to join the user table twice, one time for the recipient and one time for the author.

Something like this (approximate syntaxe) :

Code:

SELECT *
FROM messages m
JOIN users u1 having (u1.userid = m.authorid)
JOIN users u2 having (u2.userid = m.recipientid)

Tchule