Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join? Explain the different types of mysql joins.
- 1 Answers
- 1385 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
Differentiate CHAR_LENGTH and LENGTH?
How to run 'mysql' commands from a batch file?
How do I kill a mysql query?
Can you tell how to find the number of rows in a resultset using php?
Is mariadb faster than mysql?
What are the types of database engines available in mysql?
How can I insert images into a Mysql database?
Explain the difference between procedure and function in mysql?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
List data types in mysql? Explain
How large can a mysql database become?
How to upload a large file through phpmyadmin in mysql?
What is pdo :: fetch_assoc?
How do I save in mysql?
What is pdo connection?
