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 are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

0 Answers  


What is the usage of regular expressions in mysql?

0 Answers  


Can a table have multiple primary keys?

0 Answers  


Can you tell the difference between $message and $$message?

0 Answers  


What mysql means?

0 Answers  


How do I download mysql on my laptop?

0 Answers  


What happens if you no create privilege in a database?

0 Answers  


How would you enter characters as hex numbers?

0 Answers  


What is 1nf 2nf 3nf?

0 Answers  


In which language mysql has been written?

0 Answers  


Is mysql connect deprecated?

0 Answers  


Write a command to view mysql database table structure?

0 Answers  


Categories