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

How to change the database engine in mysql?

1067

What are the types of queries?

984

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1170

How to connect html form to mysql database using php?

989

What is a crosstab query?

1008

How to enter numeric values as hex numbers?

1031

How do you login to MySql using Unix shell?

1229

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2167

What is the insert?

944

write a command to view the content of the table

945

Why mysql is used with php?

1020

How do I insert multiple rows in a table?

947

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

961

In which format data is stored in mysql database?

1047

What are the 'mysql' command line options?

1044