davidbensen
10/20/2017 - 6:45 PM

SQL Person Join

SQL Person Join

This is a test of a SQL gist 

SELECT *
FROM Person P
INNER JOIN GroupMember FM ON FM.PersonId = P.Id
INNER JOIN [Group] F ON F.Id = FM.GroupId AND F.GroupTypeId = 10
INNER JOIN GroupLocation GL	 ON GL.GroupId = F.Id
INNER JOIN Location L ON L.Id = GL.LocationId