What I want is hopefully explained by the following:
INNER JOIN tblCommands ON tblObjectCommands.commandID=tblCommands.id
INNER JOIN tblObjects ON tblObjectCommands.objectID=tblObjects.id
INNER JOIN tblRooms ON tblObjectCommands.roomID=tblRooms.id
...which doesn't work. I get an error from Access about missing operators in query expressions.
I tried recreating this query using Access's query builder thing, and it gave me something that didn't pull out the rows I was expecting it to, and that had far too many brackets round it to be healthy.
Could someone show me how to write the above query so that Access likes it?