SELECT A.* FROM B_GroupOrgTree A, B_GroupOrgTree_RelatedPerson B
WHERE A.OrgIDFullPath LIKE '%'+B.OrgID+'%'
and UserID='17FC402F-A1B2-4A36-AFD8-5A1D094E9992' AND PersonRoleEnumID=15523
WHERE A.OrgIDFullPath LIKE '%'+B.OrgID+'%'
and UserID='17FC402F-A1B2-4A36-AFD8-5A1D094E9992' AND PersonRoleEnumID=15523