Build a Database of Video Game Characters

Backend Development
1

Hi. I can’t get passed this one: Now you can see all the info from both tables. If you recall, that’s a “one-to-one” relationship. So there’s one row in each table that matches a row from the other. Use another JOIN command to view the characters and sounds tables together. They both use the character_id column for their keys as well.

I used this: SELECT *
FROM characters
JOIN sounds
ON characters.character_id = sounds.character_id;

2

This is what I’ve been told: If it still repeats (most likely outcome)

Then you’ve hit the hard checkpoint bug.

At this point:

:white_check_mark: You have completed the requirement

The lesson text says:

“Use another JOIN command to view the characters and sounds tables together.”

You did exactly that, multiple times, correctly.

:cross_mark: The checker state is corrupted

No amount of SQL changes will fix it.

3

can you post a screen shot of the current step and the command you typed?

4

Thanks. After many attempts, I finally got past the 98% mark and finished! :slight_smile:

1 Like