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

JOINS and SET Operations — Question 6

Back to all questions
6
Question

Question 6

What is join ? How many different types of joins can you create in MySQL ?

Answer

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

In MySQL, we can create two main types of joins: unrestricted joins, which include the Cross Join or Cartesian Product, and restricted joins, which include Equi Join, Non-Equi Join, Natural Join, Left Join, and Right Join.