Database - Advanced SQL - Discussion
Discussion Forum : Advanced SQL - General Questions (Q.No. 8)
8.
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 WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
Discussion:
6 comments Page 1 of 1.
Mohammad Yahia said:
10 years ago
Natural-join : It joins two tables on the columns with common name but displaying one of them.
Equi-join: It join on equality condition between two columns.
SQL
select
from
where a.x=b.x
Is always Equi-join?
It may be natural-join only if x selected once.
Equi-join: It join on equality condition between two columns.
SQL
select
from
where a.x=b.x
Is always Equi-join?
It may be natural-join only if x selected once.
Kalyan said:
1 decade ago
How it is equal join? Please explain.
Neha Sharma said:
1 decade ago
Why not "Natural join"?
It is also a case where equality condition is used on same column.
It is also a case where equality condition is used on same column.
Nyna insan said:
1 decade ago
equi-join joins only same data entry field for example one table contains department id and another table should contain department id.
(1)
Sheetal said:
1 decade ago
Why not natural-join or inner join?
Otis said:
1 decade ago
How do someone notice that this is an equi-join?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers