SQL Server Inner Join Multiple Tables You can join more than two tables using the inner join clause. The following statement joins the candidates, employees, and departments tables.