Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 51 of 91

JOINS and SET Operations — Question 2

Back to all questions
2
Question

Question 2

What is a join ? How is natural join different from an equi-join ?

Answer

A join is a query that combines rows from two or more tables based on a condition.

The join in which only one of the identical columns from the joined tables exists is called a natural join, while the join in which columns are compared for equality is called an equi-join.