My gut and a cursory Internet search on SQL JOIN deletes say, “no,” but I’m a measly 1% away from finishing the Mario SQL Database tutorial on fCC’s Relational Databases Curriculum, have misidentified my junction table, and have incorrectly joined three tables as a result. I am most likely just embarrassing myself by posting this here and have resigned myself to the prospect of redoing this entire tutorial, but I write this post on the off-chance that it IS possible lol. You can be honest with me… just end my misery.
My creation:
The actual code (‘character_actions’ being the junction table, not ‘actions’):
SELECT * FROM character_actions FULL JOIN characters ON character_actions.character_id = characters.character_id FULL JOIN actions ON character_actions.action_id = actions.action_id;