Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is JOIN? Give example & types of join?

Answer Posted / neha gupta

The act of joining in MySQL refers to smashing two or more
tables into a single table.In short, a join command unites
some or all of the data from two or more tables into one
comprehensive structure.

Types of Join

1. Inner Join
2. Outer Join
Left Outer Join
Right Outer Join
3. Self Join

Is This Answer Correct ?    81 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to calculate the difference between two time values?

914


What is a deterministic function?

1006


How to delete a column and add a new column to database

892


How does php communicate with mysql?

848


What is the difference between unix timestamp and mysql timestamp?

994


How can I connect mysql database?

849


How do I show all mysql databases?

920


How do I run a query in mysql?

894


How can you filter the duplicate data while retrieving records from the table?

845


How do I start mysql client?

896


How to create a new view in mysql?

871


How can you validate emails using a single query?

837


What language is used in mysql?

935


What are the differences between binary and varbinary?

964


Write a query to stop mysql in unix

994