How to check for mutual existence of Fields in same table in Two columns
- by ranabra
I tried using "Exist" and "IN". Not only did I not succeed, it didn't seem as an efficient solution.
Here is a simplified example:
TblMyTable
WorkerUserName - WorkerDegree - ManagerUserName - ManagerDegree
I need a query where there is a mutual connection / existence.
What I mean is only where the worker,…