primary key AS pkid
  table2_primary-key AS id1
  table2_primary-key AS id2
  rating
  date

primary key AS pkid
 name

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;

select
  a.pkid, b.name,
  case when c.name is null then 'system' else c.name end,
  a.rating, a.date
from table1 a
left join table2 b on a.id1 = b.pkid
left join table2 c on a.id2 = c.pkid

SELECT A.PKID, B.NAME, C.NAME, A.RATING, A.NAME
FROM TABLE1 A
LEFT JOIN TABLE2 B ON A.ID1=B.PKID
LEFT JOIN TABLE2 C ON A.ID2=C.PKID;