You didn't provide information about DBMS. Nevertheless...
The number of tables available to join within single query depends on DBMS...
A "typical" query looks like:
SELECT A.<List_Of_Fields>, B.<List_Of_Fields>, C.<List_Of_Fields>, D.<List_Of_Fields>
FROM Table1 AS A
INNER JOIN Table2 AS B ON A.PrimaryKey = B.ForeignKey
INNER JOIN Table3 AS C ON B.PrimaryKey = C.ForeignKey
INNER JOIN Table4 AS D ON C.PrimaryKey = D.ForeignKey
There's few types of joins. See:
Visual Representation of SQL Joins[
^]
For further details, please see:
MS SQL Server:
Querying with Joins[
^]
MS Access:
Join tables and queries - Access[
^]