Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join? Explain the different types of mysql joins.
- 1 Answers
- 1321 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
What is mysql primary key?
What is longblob in mysql?
How do you rename a table?
How would you enter characters as hex numbers?
What is int mysql?
What is longblob?
What is sql in mysql?
How do I flush privileges in mysql?
How does triggers work in mysql?
Is there a free version of mysql?
Can we use mysql and mysqli together?
How to get nth highest salary from table in a mysql?
How big is a blob mysql?
What is ddl, dml, and dcl?
How many ways we can retrieve the date in result set of mysql using php?
