what is JOIN? Give example & types of join?
Answer Posted / neha gupta
The act of joining in MySQL refers to smashing two or more
tables into a single table.In short, a join command unites
some or all of the data from two or more tables into one
comprehensive structure.
Types of Join
1. Inner Join
2. Outer Join
Left Outer Join
Right Outer Join
3. Self Join
Is This Answer Correct ? | 81 Yes | 12 No |
Post New Answer View All Answers
How do I flush privileges in mysql?
What are the critical issues you have resolved in your company
How to see table's field formats or description of table .
Can mysql handle billions of records?
How do I export mysql query results to excel?
How can you retrieve a portion of any column value by using a select query?
Which statement is used in a select query for partial matching?
What is mysql connection limit?
How does select query work?
How to create and drop view in mysql?
What are the two types of queries?
What is inner join in mysql?
Where MyISAM table will be stored and also give their formats of storage?
Can you tell how many values can set the function of mysql to consider?
How do I connect to a mysql database?