CREATE TABLE ROLES (role_code VARCHAR, role_name VARCHAR)
CREATE TABLE Employees (employee_id VARCHAR, role_code VARCHAR)

Show the employee ids for all employees with role name 'Human Resource' or 'Manager'.
SELECT T1.employee_id FROM Employees AS T1 JOIN ROLES AS T2 ON T1.role_code = T2.role_code WHERE T2.role_name = "Human Resource" OR T2.role_name = "Manager"
SELECT "T1"."employee_id" FROM "Employees" AS "T1" JOIN "ROLES" AS "T2" ON ("Human Resource" = "T2"."role_name" OR "Manager" = "T2"."role_name") AND "T1"."role_code" = "T2"."role_code"