table prizes (l_playerid, s_playerid, l_prize, s_prize)
1 - 1 - 500 - 350
2 - 1 - 650 - 245
1 - 2 - 500 - 65
2 - 2 - 150 - 85
3 - 3 - 95 - 125
5 - 2 - 350 - 205

table players (playerid, name)
1 - Bob
2 - Jay
3 - Suzie
4 - David
5 - Rick
6 - Jane

WHERE prizes.l_playerid = players.playerid OR prizes.s_playerid = players.playerid


HOW can I return this:

result (l_player_name, s_player_name)
Bob - Bob
Jay - Bob
Bob - Jay
Jay - Jay
Suzie - Suzie
Rick - Jay


With one query???

Thanks,
Rey