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

What is mysql database used for?

1092


How do I copy an entire mysql database?

946


What is mysql port?

1128


Does mysql use t sql?

1026


How to create a table index in mysql?

1016


Can you tell few best practices to be followed for optimization in sql?

975


What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2172


How do I setup a mysql database?

1039


What are ddl statements in mysql?

1130


What is 1nf 2nf 3nf?

1033


What is the password of mysql?

1014


How do I view mysql logs?

934


What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

1082


How do I rename a table in mysql workbench?

1027


What are the functions used to encrypt and decrypt the data present in mysql?

1178