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 Code: SELECT CharacterInfo.Charactername, Rooms.RoomCoordinateX, Rooms.RoomCoordinateY, Rooms.RoomCoordinateZ, Traps.Trapdescription, CharacterInfo.[Character description], CharacterInfo.characterstatus, CharacterInfo.[Health Points] FROM (Traps INNER JOIN Rooms ON Traps.[TrapID] = Rooms.[Trap]) INNER JOIN CharacterInfo ON Rooms.[RoomID] = CharacterInfo.[RoomID];