SELECT DISTINCT * FROM LegitimateKZN_NEO.DBO.Associations AS A WHERE A.AssociationID IN (SELECT DISTINCT AMD.AssociationID FROM LegitimateKZN_NEO.DBO.AssociationMemberData AS AMD) ORDER BY [AssociationName] ASC