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



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

Answer / 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

More MySQL Interview Questions

What is the insert?

0 Answers  


Write a command to view mysql database table structure?

0 Answers  


How do I check mysql version?

0 Answers  


How do I start mysql client?

0 Answers  


Is mysqli deprecated?

0 Answers  






How many sql ddl commands are supported by 'mysql'?

0 Answers  


What is blob in mysql?

0 Answers  


How to filter data from a mysql database table with php?

0 Answers  


What is the difference between GROUP BY and ORDER BY in Sql?

12 Answers   Creative, Renault Nissan, Trikon Networks,


suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

0 Answers   ACC,


What is the latest version of php and mysql?

0 Answers  


How do I change mysql password?

0 Answers  


Categories