what is JOIN? Give example & types of join?

Answer Posted / vijay

Types of join are:-
1.Outer join
*--Right Outer join
*--Left Outer join
*--Full Outer join
2.Multiple join
3.self join
4.Inner join
5.cross join

Is This Answer Correct ?    22 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can not connect to mysql server 10060?

496


How to calculate the difference between two time values?

453


Does mysql use sql?

491


What is the innodb in mysql?

504


What does innodb stand for?

525






Is sqlite faster than mysql?

490


How to extract a unit value from a date and time?

491


Where the database is stored in mysql?

491


How MySQL Optimizes DISTINCT?

611


In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

532


What is the latest version of php and mysql?

677


How do I create a mysql database?

493


What are the technical features of MySQL?

577


What is delimiter in mysql trigger?

525


How do I change the max connection in mysql?

513