Table to table ID joins

[tomcatexodus]

Hey all,

I'm having a problem getting a query to return anything on the tables I have set up on my XAMPP running MySQL 5.1.11.

The query I'm using to attempt to test this is:

SELECT * FROM card
INNER JOIN cardgame1
ON card.cardID = cardgame1.cardID
INNER JOIN cardgame2
ON card.cardID = cardgame2.cardID
WHERE card.cardID=1;

The card table holds basic information about cards like names, ID, who created them, etc., whereas the cardgame1, cardgame2, etc., tables hold more game specific values about the different games.

cardgame1, 2, and so on, are config'd with a foreign key pointing back to card.

Anyways, given a cardID, I'm trying to pull all the data from all the tables with that ID (since all the cardgames share IDs from the card table, only one table's results should have any values. this is fine, because I can parse that easily)

Any ideas? should I revamp my table structure?

thanks in advance

EDIT:

oh yea.. the problem is i'm getting 0 rows fetched.