problem with inner join

Hi guys,
I'm having a problem with my database.
Im busy devellopping a small textbased rpg wich i want to store in an access database.
there are a few tables i want to get info out of with my query.
*characterinfo : information of the characters playing
*Rooms : the different rooms in the game
*Traps : the traps in the rooms

What I have in mind of getting is quit simple
I want to be able to see each characters location, with their respective traps at that location.
here is my code