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

calling or handling data without c# model

 calling or handling data without c# model Yes, it is possible to read data in a C# Web API without explicitly defining model classes for ev...