How to automatically establish a table's join expression in Access

Access connections can generate a meaningful view or SQL virtual set with the following connections:
Inner JOIN (natural connection): Only rows matching two tables can appear in the result set
Outer joins: include left outer joins (the table on the left is unrestricted), the right outer join (the table on the right is unrestricted), all outer joins (both tables are unrestricted), since the connection (the connection takes place in a base table)
Access provides a simple connection expression generation tool----query. How TO:
Go to query, select Use Wizard to create a query, select the fields that you want to appear in the result set (which can come from multiple base tables), and press Finish. In the menu view--SQL view, you can see an inline join expression that is automatically generated.
Such as:
SELECT [Types]. [Type], [URLs]. [Name], [URLs]. [URL] From Types INNER JOIN URL on [Types]. [typeID] =[urls]. [typeID]
Note: The base table name and field names need to be preceded by a "[]" number.
Body