Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join? Explain the different types of mysql joins.
- 1 Answers
- 1314 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 do I add a column to a table in mysql?
What is mysql command line?
What does mysqli_fetch_assoc do?
What is timestamp in mysql?
Is mysql better than oracle?
Is mysql an oracle product?
What is identity in mysql?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
What are the steps required to view your mysql database?
Write a command to view mysql database table structure?
What are stored procedures and functions?
what is the default port for mysql server? : Mysql dba
-
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)
