Quote Originally Posted by OBP
Assuming that you want to use the established Relationships for your Joins you can use the System Table "MSysRelationships" to find the "names" of the Relationships and which Tables and Fields they are joined by.
Tony,
I don't know whether the OP wants to use predefined relationships or ad-hoc created links in the query. That's his job to decide. My personal feeling is that he wants the latter, because otherwise he wouldn't want the user to specify a 'join type' in the query builder form, since that info is already part of relationships.

In case of 2 tables, SQL syntax for JOIN is very straightforward, yes.
What troubles me is the case of 3-4 or more tables, which looks a little less easy. Just choose any query in one of your databases that has several joint tables, and take a look at its SQL string. You will see lots of round brackets. If you remove them, Access will give a syntax error message, so it seems that brackets are obligatory.

I still couldn't quite grasp the logic behind the rules of using brackets, for sometimes there are more of them than what seems reasonable. Also, I'm confused about the order of tables, as they succeed one another in the SQL.

Unfortunately, the code you provided doesn't use brackets at all, and doesn't tell anything about table order. I personally am very curious how the source you referred to does these things. You can explore, if you want, or you could share a link for that source.

Jimmy