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

what is JOIN? Give example & types of join?

Question Posted / vijay

14 Answers
42936 Views
iMedia, Millennium, RAM Software, Satyam, I also Faced
E-Mail Answers

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

What is the default port for mysql and how it can change?

1108

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

935

How do I run mysql on a mac?

1010

What are programming functions?

998

How to dump a table from a database.

1077

What is full text indexing in mysql?

995

What does mysql flush tables do?

1008

How to show certain selected rows with the value "pcds".

982

How to declare variable in mysql trigger?

1064

What is a tinyint?

996

Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

1072

How to display top 10 rows in mysql?

1088

What are the similarities between a function and a procedure?

958

What are date and time data types in mysql?

1069

How can we encrypt and decrypt a data presented in a table using mysql?

1137