Monday, 22 September 2025

Find the missing data comparing two users. same table

 SELECT a.Site_Location

FROM tbl_UserAccessEntities a

LEFT JOIN tbl_UserAccessEntities b

    ON a.Site_Location = b.Site_Location

   AND b.User_ID = 'EROOSENSCHOON'

   AND b.country_code = 'US'

   AND b.Division_ID = 'msv'

WHERE a.User_ID = 'Scooper'

  AND a.country_code = 'US'

  AND a.Division_ID = 'msv'

  AND b.Site_Location IS NULL;




No comments:

Post a Comment

Enviri JD for BI

  Job Description: Experience working closely with business users/leaders. Well-versed in requirement gathering and can lead business users ...