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 / srikanth keshavena

Basically join's are three type's those are :

1.Cross join
2.Equi join
a.Natural join
b.inner join
c.outer join(Simple join)
i.Left outer join
ii.Right outer join
iii.FUll outer join
3.Non-equi join

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by database schema and what does it hold?

1230


How to divide query output into groups in oracle?

992


How to update values on multiple rows in oracle?

1034


How to use select statement to count the number of rows in oracle?

1046


How to convert dates to characters in oracle?

1042


How to use in conditions in oracle?

1058


How to return top 5 rows in oracle?

1062


How does oracle handle read consistency?

1097


How to create a testing table in oracle?

990


How to define and use table alias names in oracle?

943


How to convert characters to times in oracle?

1023


Give the different types of rollback segments.

1031


How can you use check constraints for self referential integrity?

971


How do I find the database name in oracle?

1039


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007