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

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different mysql database engines?

1054

What happens if null values are involved in expressions?

973

What is federated tables in mysql?

860

What is mysql server used for?

884

What is the use of i-am-a-dummy flag in mysql?

949

What is a delimiter in mysql?

934

Why should I use mysql?

869

How to insert dynamic values in mysql using php?

1078

What are all the Common SQL Function?

1047

Write a query to create a database and a table?

848

What is root password?

849

How to enable or disable a row of a table using MySQL in struts?

4033

What is key in mysql?

833

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

2072

How do I rename a table in mysql workbench?

901