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

Write a query to fetch common records between two tables using mysql?

1069

What is cast in mysql?

955

How do I drop a database in mysql?

1171

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1179

What is longblob in mysql?

1018

How do you know the version of your mysql server?

1226

What are the functions of commit and rollback statements?

1104

What is regex in mysql?

1145

What is blob and text in mysql?

1216

What is mysql root?

999

How to insert html code into mysql database using php?

1123

How to rename an existing column in a table?

1111

Why do we need mysql?

1021

What are numeric data types?

1043

How to copy data from one server to another using php?

1113