Question 2 - Past Year - 2 Mark Questions - Chapter 9 - Structured Query Language

Define Equi join.

Answer:

Equi Join is a simple SQL join which uses the equal sign as the comparison operator.

It combines tables by matching values in specified columns.

Syntax:

SELECT column_list

FROM table1, table2....

WHERE table1.column_name = table2.column_name ; 

OR

SELECT column_list

FROM table1  

JOIN table2

[ON ( join_condition ) ]

Example:

Additional points:

• The column names of columns specified for joining need not be the same.
• The resultant table will contain repeated columns.
• Equi Join can be performed on more than 2 tables.