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 is rank function?

0 Answers  

---

why would you call update statistics? : Sql server database administration

0 Answers  

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---

How to start and end transact-sql statements?

0 Answers  

---

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

---

What are the authentication modes in sql server? How can it be changed?

0 Answers  

---

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---

What is query optimizer in sql server?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What are magic tables in sql server?

0 Answers  

---

What is a SQL Server Temporary Table?

1 Answers   Wipro,

---

What is the cpu pressure?

0 Answers  

---