Learn Relational Databases by Building a Mario Database - Build a Mario Database

Tell us what’s happening:

Hi, I’m finishing Mario DataBase. And when this exercise come across:

“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.”

The solution is:
SELECT * FROM characters FULL JOIN sounds ON characters.character_id = sounds.character_id;

But it produces an error:

You should view all the data from “characters” and “sounds” with a JOIN statement

Your code so far

SELECT * FROM characters FULL JOIN sounds ON characters.character_id = sounds.character_id;

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36

Challenge: Learn Relational Databases by Building a Mario Database - Build a Mario Database

Link to the challenge:

You seem to be entering the right command @JuanD13Perez. Can you share a screen shot? Maybe someone can see something that isn’t right.

Did you try hitting the reset button? That will reset things to the start of the step. Perhaps something isn’t quite right in the database that the tests are looking for.