What is Cross Join

Question Posted / ramesh

3 Answers
5245 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is Cross Join..

Answer / ramesh

A join with out condition is called CrossJoin.
It also called as cartesionjoin.
It produces resultset where every row is first table joined
with every row in second table.

Is This Answer Correct ?

5 Yes

1 No

What is Cross Join..

Answer / kuldeep sharma

SQL Cross Join...>Cartesian product of both tables.

Example:
Let left table has 10 rows and right table has 8 rows then
SQL CROSS Join will return 180 rows combining each record
of left table with all records of right side table.
Consider the following example of CROSS Join:

USE PUBS
SELECT AU_FNAME, AU_LNAME, PUB_NAME
FROM AUTHORS CROSS JOIN PUBLISHERS
ORDER BY AU_FNAME

Above cross join will return 23 * 8 = 184 results by
multiplying each row of authors table with publishers table.

Is This Answer Correct ?

1 Yes

0 No

What is Cross Join..

Answer / colin

A small error kuldeep..if left table has 10 rows n right
table has 8 rows..then a cross join wud return 80 rows
(10*8)..besides dis ur totally ryt.. Cross joins are also
called cartesian product..

Is This Answer Correct ?

1 Yes

0 No

Post New Answer