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.

983 students joined Teachoo Black. What are you waiting for?

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.