Database - Advanced SQL - Discussion
Discussion Forum : 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 ;
Discussion:
4 comments Page 1 of 1.
Anomie said:
2 years ago
How to identify which join is applied? Anyone, explain me clearly.
Lakshmiprasad said:
9 years ago
There is no identification for finding cross joining.
(1)
Rahul said:
1 decade ago
When we don't use the WHERE in the sql statements. Then it is cleary a cartesian join.
(3)
Rizwan Ali said:
1 decade ago
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.
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.
(1)
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers