Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join? Explain the different types of mysql joins.
- 1 Answers
- 1315 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 does mysql_query return?
What is federated tables in mysql?
Can I copy mysql data directory?
How does mysql store binary data?
How to check if value already exists in mysql database in php?
Do I need to pay for mysql?
How to use sum function in where clause in mysql?
How do I import database through command line?
Is mysql free software?
How to create a new table in mysql?
How do I change mysql password?
Write a query to retrieve a hundred books starting from 20th.
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
What is the difference between timestamp and datetime in mysql?
Is oracle mysql free?
