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 download a mysql community server?
How to delete a trigger in mysql?
What are the limitations of mysql?
What are triggers in mysql?
What is back end and front end?
What is the purpose of using timestamp data type?
What is datatype in mysql?
Is mysql a framework?
What is data types in mysql?
How can we optimize stored procedure?
What is the difference between database and table?
Is mysql open source?
How to include numeric values in sql statements?
How do I install mysql?
How do I get a list of table names in mysql?