I am just selecting on a query that contain cartesian records. How do I get rid of these records in my query?
SELECT distinct newEmpid,
where newEmpid = 'e199702275'
see attachment for the records
I am getting 4 records but I only want 2