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.
