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