Is this connection between tables posible ?

[Georgi Georgiev]

http://egorig.hit.bg/Stuff/mysql.gif

First table : four fields - r_id, r_f1, r_f2, r_rez
Second table : three fields - t_id, t_name, t_st

r_f1 and r_f2 are indexes (example: 3 and 6) (Always different)
I want to select r_rez and the both names (t_name) from the second table which correspond to r_f1 and r_f2

Suggestions? Is it possible?