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

Is mysql easy to learn?

948

How many threads can mysql handle?

973

How to represent ENUMs and SETs internally?

1131

How do I change mysql password?

1017

what is the difference between between and in operators in mysql?

1033

What is row?

1082

How can you plan the logshipping before processing?

2339

What is the difference between heap table and temporary table?

1113

What are the column comparisons operators?

1238

How to Join tables on common columns.

1184

What is a mysql view?

840

What is the data type for file in mysql?

987

What is the usage of regular expressions in mysql?

902

What is the datatype of image in mysql?

919

In mysql, what is joins? Explain

969