Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join? Explain the different types of mysql joins.
- 1 Answers
- 1458 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 sql in mysql?
How to return query output in html format?
What are the different types of triggers in mysql?
What is msql?
What is the difference between mysql and pdo?
What is a simple query?
What is not null in mysql?
How many sql ddl commands are supported by 'mysql'?
How you can create a trigger in mysql?
What is 'mysqladmin' in mysql?
What is mysql server?
What is foreign key in mysql?
How to drop an existing index in mysql?
How can you see all indexes defined for a table?
Why is mysql used?
