Monday, 9 June 2025

User 1 has not site compare to user 2

 SELECT Site_Location 

FROM tbl_Users 

WHERE User_ID = 'sboissinot' 

AND Site_Location NOT IN (

    SELECT Site_Location 

    FROM tbl_Users 

    WHERE User_ID = 'swoodhouse'

)


No comments:

Post a Comment

SQL Case studies

 https://drive.google.com/drive/folders/1uOX7A6r5SDN6NXhVtHc4lNWRYOwjhtE1