Cross join it is otherwise called cartesian join

Which one of the following join types will always create a
Cartesian Product?

1. CROSS JOIN
2. LEFT OUTER JOIN
3. RIGHT OUTER JOIN
4. FULL OUTER JOIN
5. INNER JOIN

Question Posted / kumar srinivasalu

2 Answers
7288 Views
I also Faced
E-Mail Answers

Answer Posted / kumar srinivasalu

Cross join it is otherwise called cartesian join

Is This Answer Correct ?

14 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql analyzer?

995

What is an alias command?

1038

What is the difference between a subquery and a join?

1073

How does cross join work?

918

how to fetch common records from two tables? : Sql dba

1155

Why do we use procedures in pl sql?

1007

What is raid? How does it help storage of databases?

1066

what is a composite primary key ? : Sql dba

1025

What are string functions in sql?

1219

How to run sql commands in sql*plus?

1155

Why we use cross join?

937

Can a foreign key have a different name?

932

Can we use ddl statements in stored procedure sql server?

989

What is a constraint? Tell me about its various levels.

1139

What is sql lookup?

905