Comparing two columns

[Former Member]

Hi All,

I am trying to derive whether a person is manager or not.

I have data in below format:

Managerid EmpId

123 456

123 678

678 101

101 111

I am trying to achieve below format:

Managerid EmpId Is_EMP_Manager

123 456 No

123 678 Yes

678 101 Yes

101 111 No

So each Empid should compare all values in Managerid, If its present then he is manager If not present he is not a manger.

Any Inputs. Thanks

[Former Member · Accepted solution]

Hi,

try instead of bringing manager and emp id on the same query, create 2 queries, one bringing the manager id and emp id, then try using this approach.

Regards,

Rogerio