We have a scenario of accounts who have contacts where some have one or more records in a custom object named members__c but not all contacts have a member__c record. member__c object has a lookup relationship with the contact object.
How to select all contacts who have at least one member__c record and insert their first and last name in a field named "member__c" on the account object?