With a correlated subquery, the EXISTS clause is evaluated separately for each row of the table referenced in outer query,
- SELECT PK_EMP_CODE FROM MSTEMPLOYEE MS
- WHERE EXISTS(
- SELECT FK_EMP_ID FROM SANCTIONDETAILS SA WHERE SA.FK_SANC_EMPID='UTL001'
-
- AND MS.PK_EMP_CODE=SA.FK_EMP_ID
- )