Просмотр поста #96484: Различные вопросы по PHP и MySQL

Screamer,

SELECT users.id, users.nickname
FROM `mail_messages` 
JOIN `users` ON ((
mail_messages.sender = users.id
AND mail_messages.archive =1
)
OR (
mail_messages.receiver = users.id
AND mail_messages.archive =2
)
)
AND mail_messages.id =3