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

Can python connect to mysql?

486


How do I select a database in mysql?

495


What are the advantages of MySQL when compared with Oracle?

539


How do I edit a database in mysql workbench?

488


What is back end and front end?

470






What is mysqli_num?

508


Why do we use group by and order by function in mysql?

525


Is there a way to see the files which are stored?

495


How do I clear the command in mysql?

499


Who owns mysql database?

579


Can I install mysql on mac?

526


What mysql means?

493


Is mysql a programming language?

450


What is 'mysqldump'?

526


How do I start mysql from command line?

513