Joins can be used to connect any number of tables.

You use the following formula to calculate the number of joins you will need in your WHERE clause:

Number of joins = the number of tables used in the query – 1