Thanks Roelf, yes that solved my syntax woes.
However; it's not pulling out the results I expected.
I have the following:
[T1].[roomDescription] AS inRoomDesc,
[T1].[id] AS inRoomID,
[T1].[roomName] AS inRoom,
[tblRoomDirections].[targetRoomID] AS toRoomID,
[T2].[roomName] AS toRoom,
FROM ((([tblRooms] T1 INNER JOIN [tblRoomDirections] ON [tblRoomDirections].[roomID] = [T1].[id])
INNER JOIN [tblObjectRooms] ON [tblObjectRooms].[roomID] = [T1].[id])
INNER JOIN [tblObjects] ON [tblObjects].[id] = [tblObjectRooms].[objectID])
INNER JOIN [tblRooms] T2 ON [tblRoomDirections].[roomID] = [T2].[id]
As you can see, I've replaced both calls to join tblRooms, with aliases.
The problem is with the "toRoom" column. The "toRoomID" column is correctly pulling out a list of room ID's that the user can get to from the current room, but it's not matching the ID's to those rooms' respective names: the "toRoom" column always shows the name of the current room. I've attached a 4k gif example result set.
Once more, what am I doing wrong?
(actually, looking at it again, I notice that I've got tblRoomDirections in two INNER JOIN calls - should I be using aliases for this, too? If so could you give me an example as I can't really get my head round which columns to pull from which alias, or even if it matters