help with easy mysql query - show name of clients with "gold" card

[ket]

Hello fellas,

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!

[r937]

what have you tried?

[ket]

hi r937,

i'm trying as we speak. i'm suppose to use inner join, right?

thanks.

[r937]

yes

[ket]

i've tried the following code with no success, still reading more about it..

SELECT cards.type, clients.name
FROM cards
INNER JOIN clients ON cards.type= clients.id_cliente
WHERE cards.type= 'gold'

do i need to SELECT the clients.id_client as well?

[ket]

after reading and checking this example, i was able to create the following query:

SELECT clients.name, cards.type, cards.id_client
FROM clients
INNER JOIN cards
ON clients.id_client = cards.id_client
WHERE cards.type = 'gold'

correct? right?

[r937]

correct? right?

what happened when you tested it?

[ket]

well, it displayed the names of the clients that have the Gold card, just like i wanted

[r937]

glad i could help

[ket]

eheheh rudy, thanks for the help