5
Cross Join | cross join SQL | Join - A cross join (also called a Cartesian join) is a join of tables without specifying the join condition,the query would return all possible combination of the tables in the SQL query.The SQL CROSS JOIN produces a result set which is the number of rows in the first table multiplied by the number of rows in the second table if no WHERE clause is used along with CROSS JOIN.This kind of result is called as Cartesian Product.

Comments

Who Upvoted this Story

What is Plikli?

Plikli is an open source content management system that lets you easily create your own user-powered website.

Latest Comments
Statistics