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

Which storage engine is best in mysql?

952

How many columns can a table have?

922

What is procedures in mysql?

940

How to run a sql statement?

1036

What is the use of count function in mysql?

1029

what are the different tables present in mysql? : Mysql dba

1018

How do I run a query in mysql?

943

What are the advantages of mysql in comparison to oracle?

1027

What are mysql data types?

1001

Difference between CHAR and VARCHAR?

1101

Can you tell the difference between ereg_replace() and eregi_replace()?

1037

What is blob and clob?

947

Where is the mysql database stored?

911

What is the full meaning of mysql?

969

How do I copy an entire mysql database?

898