Joins can be used to connect any number of tables.
The number of joins you will need in your WHERE clause is total_number_of_tables - 1
There are two types of join conditions, which are based on the operator.
Equijoins - You use the equality operator (=) in the join.
Non-equijoins - You use an operator other than equals in the join, such as , BETWEEN, and so on.