types of joins are cross join inner or equi join left join right join

what is JOIN? Give example & types of join?

Question Posted / amita

Answer Posted / amita

types of joins are
cross join
inner or equi join
left join
right join
outer join

Is This Answer Correct ?

31 Yes

19 No

Please Help Members By Posting Answers For Below Questions

In mysql, what is the default storage engine?

1000

What causes mysql too many connections?

952

Explain Access Control Lists.

986

What are the advantages of mysql in comparison to oracle?

1024

What is difference between mysql_connect and mysql_pconnect?

1034

What is the difference between primary key and candidate key?

1014

Why mysql is open source?

911

Where is the myisam table stored?

958

What is ndb in mysql?

959

What is the purpose of using timestamp data type?

916

Is mysql a server?

901

What is datatype in mysql?

942

What is difference between mongodb and mysql?

910

What is the default port of mysql server?

1025

In which language it is written?

945