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


Please Help Members By Posting Answers For Below Questions

How do I download a mysql community server?

637


How to delete a trigger in mysql?

673


What are the limitations of mysql?

717


What are triggers in mysql?

647


What is back end and front end?

667


What is the purpose of using timestamp data type?

676


What is datatype in mysql?

649


Is mysql a framework?

657


What is data types in mysql?

652


How can we optimize stored procedure?

689


What is the difference between database and table?

739


Is mysql open source?

655


How to include numeric values in sql statements?

706


How do I install mysql?

663


How do I get a list of table names in mysql?

667