Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   problem with inner join (http://www.go4expert.com/forums/inner-join-t24124/)

mistermetal 9Dec2010 02:13

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

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];

All times are GMT +5.5. The time now is 14:18.