what is JOIN? Give example & types of join?

Answer Posted / ammu

joins are nothing but a condition that combines two or more table resulting with an single table
types of joins :
--> inner join
*equi join
*cross join
--> outer join
*left outer join
*right outer join
*full outer join
--> self join

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many triggers are possible in mysql?

508


What is mysql community edition?

512


What is the difference between the primary and unique key in mysql?

457


can you tell what are the different set operations available in mysql? : Mysql dba

510


Where is mysql used?

522






What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

527


What are Heap tables?

837


What does mysqli_fetch_assoc do?

486


How do you know the version of your mysql server?

550


What is indexing in mysql?

459


What is the datatype for password in mysql?

519


How do I create a schema in mysql?

471


Is mysql a free database?

485


What is the storage engine for mysql?

496


Can mysql scale horizontally?

500