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.

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.

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..

What are the types of joins in sql?

0 Answers  

---

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

---

What is triggers and its types?

0 Answers  

---

How can I get data from a database on another server?

0 Answers  

---

How to use “drop” keyword in sql server and give an example?

0 Answers  

---

What are dml triggers and types of dml triggers?

0 Answers  

---

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,

---

Do you know what are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

Differentiate between a local and a global temporary table?

0 Answers  

---

How do you Implement SSIS Packages in your Project?

0 Answers  

---