Database - Advanced SQL - Discussion

Discussion :: Advanced SQL - General Questions (Q.No.14)

14. 

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

[A]. Equi-join
[B]. Natural join
[C]. Outer join
[D]. Cartesian join

Answer: Option D

Explanation:

No answer description available for this question.

Rizwan Ali said: (Jan 22, 2011)  
Cartesian Join is simply the joining of one or more table which return the product of all the rows in these tables.

Example:

Let table CUSTOMER_T has 500 rows and ORDER_T HAS 3000 rows then it return 500*3000=1500000 rows which contains redundant rows means unnecessary rows.

Rahul said: (Oct 4, 2011)  
When we don't use the WHERE in the sql statements. Then it is cleary a cartesian join.

Lakshmiprasad said: (Sep 16, 2016)  
There is no identification for finding cross joining.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.