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 are joins..how many types of joins are there?

Answer Posted / prabhat shukla

Basically there are three types of join

1.Inner join
2.Outer join
3.self join

and there are two types of join based on condition.

1.equi-join(if we use equal operator while joining tables)
2.Non-equi-join( if we use other than equal operator while
joining tables.(this on is rarely used.)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is MTTR advisor in Oracle?

1142


Can you tell me how to add new column in existing views?how?How is possible?

1516


What is the Tune Query

2347


How will you identify oracle database software release?

1058


What is oracle rowcount?

1148


How to compare dates in oracle sql?

1162


Is primary key indexed by default in oracle?

1050


What is object data modeling?

1017


How to add a new column to an existing table in oracle?

1191


What is a data dictionary and how can it be created?

1240


Please explain oracle left join with an example?

1095


What is tns name?

1029


How to list all tables in your schema?

1120


What is Library Cache in Oracle?

1191


What is enter substitution variable in oracle?

1097