Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join? Explain the different types of mysql joins.
- 1 Answers
- 1380 Views
- I also Faced
- E-Mail Answers
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 |
How to use sum function in where clause in mysql?
What language does mysql use?
How do I delete a table in mysql workbench?
What are the different tables present in MySQL?
Write a query to display even rows in student table using mysql?
How many ways we can we find the current date using MySQL?
How to use triggers to track changes in mysql?
What is the difference between truncate and delete in mysql?
What is a tinyint in mysql?
How do I start mysql from command line?
What is mysql cursor?
How do I copy a table in mysql workbench?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
