What is a join? Explain the different types of mysql joins.
- 1 Answers
- 989 Views
- I also Faced
- E-Mail Answers
Answer Posted / hrindows@gmail.com
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 |
Post New Answer View All Answers
How do I start mysql server?
Is primary key auto increment?
Which datatype is used for email in mysql?
How to create a new table in mysql?
How do you shutdown a mysql database?
How to find the unique values if the value in the column is repeated?
explain GROUPBY & HAVING clause with examples.
What is sql vs mysql?
How do I run mysql from command line?
How does triggers work in mysql?
How to filter data from a mysql database table with php?
What is the latest version of php and mysql?
What are different types of queries?
How do I uninstall mysql connector?
If we use sum function in mysql, does it return sum of that row or for that column?
