Hi, I'm looking for help in the following scenario, I have two tables, one with project details like project id, employee_name and employe_role and the other with employee name and manager, mock data is below. 111 AA Emp_role1 111 BB Emp_role2 111 CC Emp_role3 111 DD Emp_role4 222 DDD Emp_role3 222 EEE Emp_role4 333 AA Emp_role5 AA Manager1 BB Manager1 CC Manager1 DD Manager1 EE Manager5 FF Manager5 EEE Manager2 FFF Manager2 I wanted to compare and check if all the employees under the same project id have same manager. Additional Notes: Each employee can hold different roles in different projects but employee_name and employee_role pair is unique for each project. For example, one person named Chris cannot be a manager and a developer, hence only those employee names in the unique employee, role pairs of each project will be used to compare their managers against. Let me know if you need further details. Regards, AC
... View more