Final answer:
When related columns cannot be joined using an equals sign, a "Cross Join" is performed.
Step-by-step explanation:
A Cross Join, also known as a Cartesian Join, is performed when related columns cannot be joined using an equals sign. In this type of join, every row from the first table is combined with every row from the second table, resulting in a Cartesian product. Unlike other join types that use specified conditions for matching rows, a Cross Join does not require a specific relationship between the columns. Instead, it generates all possible combinations of rows, potentially leading to a large result set.
Cross Joins are utilized when there is no explicit relationship between columns for joining, making them suitable for cases where a Cartesian product of all rows from both tables is needed. However, it's essential to use them judiciously, as they can result in a significant number of rows and may not be suitable for all scenarios.