Need a bit of help with an easy mysql query.
I have a database with two tables:
- one table named "clients" which has 5 columns (id_client, name, address, date, and phone)
- the other table named "cards" which has 5 columns as well (id_card, bank, type, category, id_client)
The "type" column on the "cards" table is ENUM and can either be "gold" or "normal". (it's related to the type of bank card.. visa, gold, etc..)
I need a query that shows the name of the clients that have the "gold" card.
Any ideas? Thanks!