Multiple Joins from the same table?

[Kryptix]

Not really sure how to do this. Say for example you have a table with columns `sender` and `receiver` which are their ID from the users table.

 

I need to do something like...

 

SELECT `username` AS 'sender' FROM `messages` JOIN `users` ON `messages`.`sender` = `users`.`id`

 

But how would I also obtain the receiver within the same query?

[Kryptix]

Solved:

 

SELECT `a`.`username` AS 'sender', `b`.`username` AS `receiver`
FROM `messages`
JOIN `users` a ON `messages`.`sender` = `a`.`id`
JOIN `users` b ON `messages`.`receiver` = `b`.`id`