Types of join are:- 1.Outer join *--Right Outer join *--Left Outer j

what is JOIN? Give example & types of join?

Question Posted / vijay

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

Please Help Members By Posting Answers For Below Questions

How can you change the name of any existing table by using the sql statement?

940

What are the advantages and disadvantages of using mysql?

934

What is schema in mysql?

851

What does mysql_fetch_assoc do?

909

How do I install mysql workbench?

845

What is the maximum number of records in mysql table?

850

What is the usage of "i-am-a-dummy" flag in mysql?

1067

What are the differences between binary and varbinary?

964

Which is faster mysql or mongodb?

865

How many sql ddl commands are supported by 'mysql'?

1074

What are the types of queries?

896

What is a definer?

825

How many rows we can insert in a mysql table?

911

What is the usage of ENUMs in MySQL?

1064

What is the current root password of mysql?

859