what is JOIN? Give example & types of join?

Answer Posted / vijay

Join:-
Join are used to retrieve data from more than one
table simultancously .
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 ?    18 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is mariadb better than mysql?

553


How to decrement dates by 1 in mysql?

514


What are date and time functions in mysql?

573


How do I set user privileges in mysql?

482


What is the purpose of -> in the mysql terminal?

643






How we get sum of column.

508


How do you create a schema?

500


What is the use of concat() in mysql?

514


Which datatype is used for email in mysql?

484


How to drop an existing table in mysql?

557


How will show all records containing the name "sonia" and the phone number '9876543210'

527


What causes mysql too many connections?

482


What is the latest version of mysql?

499


What is data types in mysql?

483


What is the use of pdo?

514