Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is Cross Join

Answer Posted / 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..

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

981


Call by value and call by reference in procedure and function, with NOCOPY.

1244


Where are sql server user names and passwords stored in sql server?

1014


What is a result set object returned by mssql_query()?

1066


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

1020


What is partitioned view?

849


What are the types of database recovery models?

1052


How does Report Builder support Analysis Services cubes?

147


How to insert data into an existing table?

916


What is the stuff and how does it differ from the replace function?

998


Why it is recommended to avoid referencing a floating point column in the where clause?

918


When I run the sql server 2000 setup, it just hangs. What do I do?

1015


How can sql server instances be hidden? : sql server security

1050


What do you mean by a Composite primary key?

1025


Explain Capacity planning to create a database? and how to monitor it?

4140