Select a.pkid, b.name, c.name, a.rating, a.date
from table1 a, table2 b, table2 c
where a.id1=b.pkid and a.id2=c.pkid;