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

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

---

How to get the definition of a view out of the sql server?

0 Answers  

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

0 Answers  

---

Can we insert data if clustered index is disabled?

0 Answers  

---

How do I uninstall sql server 2014?

0 Answers  

---

What are the ways available in sql server to execute sql statements?

0 Answers  

---

What are different types of data sources?

0 Answers  

---

If no size is defined while creating the database, what size will the database have?

0 Answers  

---

How real and float literal values are rounded?

0 Answers  

---

What is factless fact table? : sql server analysis services, ssas

0 Answers  

---

What is fill factor and pad index?

0 Answers  

---

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

---