cross join
CROSS JOIN in T-SQL in SQL Server 2012
The type of SQL joins are: cross join, inner join and outer join.
What is this cross join?
Begin with prepare two tables wit ... e. In every our three tables are three records. So for two tables 3×3 is 9, and for three tables it will be 3x3x3 = 9×3 = 27.