what is JOIN? Give example & types of join?

Answers were Sorted based on User's Feedback



what is JOIN? Give example & types of join?..

Answer / santhi mundru

Merging two or three as a single table is called "join"
Types:
Inner Join
Outer Join
right outer join
left outer join
self join.

Is This Answer Correct ?    0 Yes 0 No

what is JOIN? Give example & types of join?..

Answer / sahib

the relationship between two or more tables
Types of join:
Three Types of joning

Is This Answer Correct ?    3 Yes 10 No

what is JOIN? Give example & types of join?..

Answer / santosh

joins are three types
equity join
natural join
conditional joins
these joins use to create conection b\w thie attributes

Is This Answer Correct ?    18 Yes 39 No

what is JOIN? Give example & types of join?..

Answer / sriram

outer join

Is This Answer Correct ?    12 Yes 35 No

Post New Answer

More MySQL Interview Questions

Can you rename a database in mysql?

0 Answers  


What is pdo mysql?

0 Answers  


Is mysql a programming language?

0 Answers  


How do I view tables in mysql workbench?

0 Answers  


maximum database size of mysql database

2 Answers  


Which is better sqlite or mysql?

0 Answers  


what is the difference between between and in operators in mysql?

0 Answers  


State the differences between mongodb and mysql.

0 Answers  


when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 Answers  


What is a text delimiter?

0 Answers  


Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 Answers  


How do you start and stop MySQL on Windows?

3 Answers  


Categories