Tell us what’s happening:
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.This one keeps givin me error, not working SELECT * FROM characters FULL JOIN sounds ON characters.character_id = sounds.character_id; and its not working. its frustrating after coming this far
Your code so far
Your browser information:
User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36
Challenge Information:
Learn Relational Databases by Building a Mario Database - Build a Mario Database