Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join? Explain the different types of mysql joins.
- 1 Answers
- 1390 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 TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
Why should I learn mysql?
What is the role of a limit in a mysql query?
How do you create a table in mysql workbench?
What is the datatype of image in mysql?
What is view in mysql?
What is mysql port?
How many entries can mysql handle?
What is the size of mysql database?
How can you import tables from a sql file into a database by using the mysql client?
How much does mysql cost?
What is the difference between procedure and function in mysql?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
Is mysql same as sql?
I want to start and stop mysql on windows? How do I do that?
