Database - Advanced SQL - Discussion
Discussion Forum : Advanced SQL - True or False (Q.No. 10)
10.
The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.
Discussion:
4 comments Page 1 of 1.
Thiyagu said:
1 decade ago
Then which join this?
Pampanag said:
10 years ago
They correlated with SET OPERATION that is UNION.
Michael Prosper said:
7 years ago
This type of join is called a natural join.
Example select * from t1 where a.x=b.y; in the case of equi-join the condition could be where a.x=b.x;
Example select * from t1 where a.x=b.y; in the case of equi-join the condition could be where a.x=b.x;
Sai said:
6 years ago
Joins are relational operators.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers