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

What is the latest mysql version?

475


How many mysql connections can handle?

490


How do I kill a mysql connection?

475


What is innodb_buffer_pool_size?

470


How do I install the latest mysql on ubuntu?

492






What is the latest version of php and mysql?

679


Why myisam is faster than innodb?

491


Why phpmyadmin is used for mysql?

505


What is row level locking in access?

488


What is pdo in mysql?

515


Explain the storage engines in mysql?

530


What is difference between mysql and mysqli?

487


How to see table's field formats or description of table .

461


What is the difference between myisam dynamic and myisam static in mysql?

497


How do you name a table?

493