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 |
Define right outer join in sql server joins?
What is a select query statement in ms sql server?
What is sql server programming?
What is sql server profiler trace data file?
What command is used to rename the database?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is the difference between HAVING clause and the WHERE clause?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is the openxml statement in sql server?
What are the differences between stored procedure and functions in SQL Server 2000?
25 Answers College School Exams Tests, HCL, Infosys, TCS,
how can we know that how many users are connected in perticuler server??????
What is sql service broker?