1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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