Check sibling questions
Computer Science - Class 12
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:

Question 2 - image.jpg

Question 2 - image 2.jpg

Question 2 - image 3.jpg

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.
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.