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 the maximum number of columns per table?

870

What is the difference between myisam dynamic and myisam static in mysql?

937

What is deterministic in mysql?

926

How many threads can mysql handle?

916

What is a tinyint in mysql?

856

How to convert character strings to numeric values?

1059

What are date and time data types?

928

What is latest version of mysql?

946

What is normalization and list the different types of normalization?

907

What is the difference between the LIKE and REGEXP operators?

976

What ascii 31?

897

What command is used to delete the data from the table without deleting the table structure?

898

Why is the basic difference between left join, right join and inner join?

969

How do I restore a database in mysql workbench?

925

How to create a new view in mysql?

871