Join:- Join are used to retrieve data from more than one table sim

what is JOIN? Give example & types of join?

Question Posted / vijay

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

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

Where is the myisam table stored?

958

How do I quit mysql?

930

What is mysql community edition?

937

How does select query work?

932

How do I start mysql in ubuntu?

1026

Do I need python for mysql?

923

What is regexp?

1127

How do I install and use mysql?

920

How do I download mysql on my laptop?

878

What is datadir?

869

Is mysql connect deprecated?

959

What does mysqli stand for?

923

What is acid in mysql?

841

What is dblink?

887

How to enter binary numbers in sql statements?

968