Answer Posted / 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 |
Post New Answer View All Answers
What are the advantages of using stored procedures?
What is wide table?
What happens when the SQL Azure database reaches Max Size?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What are the limitations in ssrs on sql server express edition?
What are the differences between stored procedure and the dynamic sql?
What are the types of resultset?
Is the log file is a part of file group?
What is model database? : SQL Server Architecture
What are the different types of collation sensitivity?
Can we call future method from queueable?
What are the approximate numeric data types?
What is the difference in accessing db between sql server vs sql azure?
What is the difference between char, varchar and nvarchar?
What is ssrs?
