select RoleName
from Table2
where the ID is not referenced/used in Table1

select RoleName from Table2 where RoleInformationID not in (select distinct(RoleID) from Table1 )

select RoleName
  from Table2 t2
  where not exists (select 1
                      from Table1 t1
                     where t1.RoleID = t2.RoleInformationID);

SELECT RoleName
FROM Table2 t2
WHERE NOT EXISTS (SELECT
   1 FROM Table1 t1 where t2.roleinformationId=t1.roleid)