I need to construct a query which will tell me if the primary key field (empl_no) appears in another field, supervisor_id, in the same table. Something like this:
----if empl_no is in supervisor_id
end as 'Manager'
Thanks so much for your help. I truly appreciate it.