1.

Define Join And Enlist Its Types?

Answer»

Joins help in explaining the relation between different TABLES. They also enable you to select data with relation to data in another table.

The various types are:

INNER JOINs: Blank rows are LEFT in the middle while more than equal to two tables are joined.

OUTER JOINs: Divided into Left Outer Join and RIGHT Outer Join. Blank rows are left at the SPECIFIED side by joining tables in other side.
Other joins are CROSS JOINs, NATURAL JOINs, EQUI JOIN and NON-EQUI JOIN.

Joins help in explaining the relation between different tables. They also enable you to select data with relation to data in another table.

The various types are:

INNER JOINs: Blank rows are left in the middle while more than equal to two tables are joined.

OUTER JOINs: Divided into Left Outer Join and Right Outer Join. Blank rows are left at the specified side by joining tables in other side.
Other joins are CROSS JOINs, NATURAL JOINs, EQUI JOIN and NON-EQUI JOIN.


Discussion

No Comment Found

Related InterviewSolutions