Merging two or three as a single table is called "join" Types:

what is JOIN? Give example & types of join?

Question Posted / santhi mundru

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is difference between oracle and mysql?

502

What is a text delimiter?

514

How do I find the size of a mysql database?

486

What are the advantages/disadvantages of mysql and php?

505

Explain the difference between procedure and function in mysql?

526

How to returns the columns and column information pertaining to the designated table.

573

What are the different mysql database engines?

535

What are the column comparisons operators?

624

How many ways we can retrieve the date in result set of mysql using php?

527

What is the maximum size of table in mysql?

563

how to display nth highest salary from a table in a mysql query? : Mysql dba

577

How can you change the name of any existing table by using the sql statement?

517

What are the 'mysql' command line options?

505

What is mysql_connect?

513

What is blob datatype in mysql?

486