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

Can I copy mysql data directory?

916


How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

927


What is session variable in mysql?

973


What is ibdata1?

895


How do you rename a table?

978


How you can create a trigger in mysql?

991


What are the indexes in mysql?

1025


How do I change a procedure in mysql?

1004


Why we use mysqli instead of mysql?

1080


What is the maximum no of columns a table can have?

906


How do I rename a procedure?

878


Is mysql a database?

938


How do I edit a table in mysql workbench?

846


How do I rename a table in mysql?

969


What is the data type for file in mysql?

981