COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Outer join
|
|
|
Natural join
|
|
|
Self Join
|
|
|
Equi join
|
Detailed explanation-1: -A natural join is a type of equi join which occurs implicitly by comparing all the same names columns in both tables. The join result has only one column for each pair of equally named columns. In other words, the Natural Join helps to join the two tables based on the same attribute name and the datatypes.
Detailed explanation-2: -The NATURAL [LEFT] JOIN of two tables is defined to be semantically equivalent to an INNER JOIN or a LEFT JOIN with a USING clause that names all columns that exist in both tables. RIGHT JOIN works analogously to LEFT JOIN .
Detailed explanation-3: -Equi join has the column name of both the tables in the resulting table whereas natural join only has one of the column names in the resulting table. The common column name of participating tables in the natural join should be the same but the common colmn name me to be different in case if Equi joins.