What is a join? Explain the different types of mysql joins.
- 2 Answers
- 1514 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
