This is the simplest the most popular join method.
By default Inner Join is in use, but you may change it:
If you want to join by different methods, just specify them like this:
It's even shorter way to join by Primary Key (assuming first table has a Foreign Key to this table)
Above joins may be combined with where clause:
Using Where clauses together with Join, introduces order into the query. Especially in the case of joining many tables.
Those kinds of queries are also very efficient.