same names

[jason farrell]

I have 2 tables. One has a list of names and the other has a message, the person it's from and the person it's to. the sql draws off the person to and from out of the list of names.

it's basically structured as:

name table:

name | id
-----------------
jackson | 1
johnson | 2


message table:

message | personto | personfrom
-------------------------------------------
bla | 1 | 2
blabla | 2 | 1

my sql so far is:
"SELECT * FROM messagetable RIGHT JOIN nametable ON messagetable.personfrom = nametable.id"


how do i join the person to in the code, because they both use the same row name, of "names"

thanks,
jason