Thanks!
Code: Select all
mysql> SELECT membership_name, people_fname
-> FROM membership,people_membership,people
-> WHERE membership.membership_id=people_membership.membership_id
-> AND
-> people.people_id=people_membership.people_id
-> AND
-> people_membership.people_id=3;
+-----------------+--------------+
| membership_name | people_fname |
+-----------------+--------------+
| AICP | John |
| PP | John |
+-----------------+--------------+