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

c# interviewquestions

 2. What is the difference between static, public, and void? 3. What is an object? 4. Define Constructors. What is the benefit of ‘using’ st...