What is Cross Join
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
I have to display ten columns values from diffrent ten tables. how many joins are require?
10 Answers CarrizalSoft Technologies, HCL,
What are the benefits of filtered indexes?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
How do I find information about the install locations for the various instances running on a computer?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What are pessimistic lock and optimistic lock?
Can we take the full database backup in log shipping?
Explain the truncate command?
Explain the categories of stored procedure?
Explain index in sql server?
What is right outer join in sql server joins?
How do we return a record set from a Stored Procedure in SQl server 2000?