problem with inner join

Discussion in 'MS Access' started by mistermetal, Dec 8, 2010.

  1. mistermetal

    mistermetal New Member

    Joined:
    Dec 8, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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];
    
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice