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 to get nth highest salary from table in a mysql?

950

What is a trigger? How you can create a trigger in mysql?

895

What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

1018

What is key in mysql?

891

What is MySQL?

994

In mysql, what is the default storage engine?

1001

What is row level locking in mysql?

1004

Is mysql an oracle product?

841

How to get a version of mysql?

1041

How to use count function in mysql?

925

How do I find mysql location?

964

How to create a new view in mysql?

922

can you tell what are the different set operations available in mysql? : Mysql dba

886

Is mysql query case sensitive?

961

What is row locking in mysql?

961