<----------------------Select Org---------------------->Aldenville Junior Athletic Club, Inc.Andover Tennis ClubBillerica Youth Basketball, Inc.Capital Area Soccer LeagueCentralville Basketball AssociationChair City SoccerDwarf Giraffe Athletic LeagueHarrisburg Area Womens Soccer LeagueHoly Name Athletic AssociationLowell Youth Soccer AssociationMalden Youth Soccer AssociationMansfield Youth WrestlingOakmont Youth Basketball LeagueRec District 1 Ward 4Somerset Youth Basketball AssociationSportsManager Demo SiteSUAASELECT R.RegistrationID,ISNULL((select TOP 1 P.PlayerId FROM Players P WHERE OD.Description like '%'+P.First+'%' AND P.OrgId=OD.OrgId AND P.FamillyId=O.AdultId),0) AS 'NewPlayerId' ,R.OrgId FROM Registration R INNER JOIN Orderdetails OD ON R.RegistrationId=OD.XID INNER JOIN Orders O ON OD.OrderId=O.OrderId WHERE R.OrgId=378 and OD.Type='R' AND O.OrderType='R' AND OD.PlayerId <> ISNULL((select TOP 1 P.PlayerId FROM Players P WHERE OD.Description like '%'+P.First+'%' AND P.OrgId=OD.OrgId AND P.FamillyId=O.AdultId),0) AND R.PlayerID>0 AND OD.JA=-1 and R.RegistrationType='P'