What is a join? Explain the different types of mysql joins.

Question Posted / pavit kumar

2 Answers
1522 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is a join? Explain the different types of mysql joins...

The SQL statement that is used to make a connection between two or more tables based on the matching columns is called a join. It is mainly used for complex queries.
Different types of SQL joins are mentioned below:
 Inner Join: It is a default join. It returns records when the values match in the joining tables.
 Left Outer Join: It returns all the records from the left table based on the matched records from the right table.
 Right Outer Join: It returns all the records from the right table based on the matched records from the left table.
 Full Outer Join: It returns all the records that match from the left or right table.

Is This Answer Correct ?

0 Yes

0 No

What is a join? Explain the different types of mysql joins...

Answer / Chandan Kumar Sharma

A JOIN in MySQL combines rows from two or more tables based on a related column between them. There are four main types of joins: INNER JOIN (returns records that have matching values in both tables), LEFT JOIN (returns all records from the left table, and the matched records from the right table), RIGHT JOIN (returns all records from the right table, and the matched records from the left table), and FULL OUTER JOIN (returns all records when there is a match in either left or right table).

Is This Answer Correct ?

0 Yes

0 No

Post New Answer