what is JOIN? Give example & types of join?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you restart mysql?

659


What is orm in mysql?

669


What is horizontally scalable?

700


How to create table with same structure of student table in mysql?

677


Write a query to stop mysql in unix

800


What are the different column comparison operators in mysql?

665


How do I use mysql?

661


Give string types available for column?

751


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

739


Write a query to select all teams that won either 1, 3, 5 or 7 games.

1040


what is mysql optimization in brief?

2121


What are the types of index?

683


How many ways to get the current time?

712


How do stored procedures work?

711


What is mysql common?

644