I have 2 database tables, one containing user information and another containing the specific corporate roles they are performing.
Some of the fields contained in these DB's are as follows:
Username, name, surname, RoleID (FK Reference to Table2) etc
ID (PK and ref from Table 1 RoleID), RoleName etc
where the ID is not referenced/used in Table1
I think you're looking for
NOT EXISTS or
select RoleName from Table2 t2 where not exists (select 1 from Table1 t1 where t1.RoleID = t2.RoleInformationID);