Hello,
I have 3 tables guests,events,users
The user table is related to events table through EventID
and the guests table is related to users table through USERid
How can I join these 3 tables
I use:
Rs.open "select * from guests inner join events on guests.eventID=events.EventID ",Conn,3,3

but it relates just guests and event tables.
I believe I should use 2 inner join but I do not know how??

SELECT *
FROM guests AS g
INNER JOIN events AS e ON e.EventID = g.EventID
INNER JOIN users AS u ON u.USERid = g.USERid

well I do not know whe I use this inner join I get this error
Syntax error (missing operator) in query expression 'e.EventID = g.EventID INNER JOIN users AS u ON u.id = g.USERid'.

The query will work on SQL Server and MySQL. If you're using Access I think you have to add a paranthesis, but I don't know where.

Try:

SELECT *
FROM (guests AS g
INNER JOIN events AS e ON e.EventID = g.EventID)
INNER JOIN users AS u ON u.USERid = g.USERid

or something like that.