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 a join and explain different types of joins?

Answer Posted / dhivya

Joins are used to fetch the records from more than one
table ,there are 4 types of joins
1.Equi-Join
2.Non-Equi-join
3.outer-join
4.Self-join

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why does this query return 0?

998


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3989


What are the 18 schemas?

1099


Explain about the hierarchical model of the database?

1091


Explain about relational database management systems?

948


Who are end users in dbms?

959


The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

974


Explain the rollup operator?

1050


I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2836


State the acid rules?

1106


What are the key features of dbms?

969


Explain the role of indexing in databases?

1109


You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1047


What are the main phases of database development?

962


Explain about network model?

985