I have a table of Members (member\_id, name, etc..) and a table of Membership (id, member\_id, membership starting date, membership expiration date) with a relation of one to many, because every year there is a new entry in Membership, per every member.

When I do :

```
SELECT * FROM members
INNER JOIN membership ON members.member_id = membership.member_id

```

I obtain multiple records for every member. How can I group records in only one record per member, that contains the MIN of membership starting date and the MAX of membership expiration date?
Thank you.