I learned by doing queries in Microsoft Access 2000, then looking at the query in "SQL View". The nice thing about Access is that it managed table relations for you, so master/detail tables are almost trivial.
Relations are another name for the tables, relations are not the joins between them.
The information about this is stored in the "Relationships Window"
relation = table. join = relationship.