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 do I find the size of a sql server database?

0 Answers  

---

Does any body please help me what question's have asked for SSRS in the interview?

0 Answers  

---

What is a materialized view?

3 Answers  

---

How to delete an existing row with delete statements in ms sql server?

0 Answers  

---

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

Define union, union all, minus, intersect?

0 Answers  

---

What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  

---

explain the storage models of olap? : Sql server database administration

0 Answers  

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---

Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  

---