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 / neet verma

A JOIN is a means for combining fields from two tables by
using values common to each.
there are three types of joins:-
1)inner join
a)eqi join
b)natural join
c)cross join
2)outer join
a)Left outer join
b)Right outer joins
c)Full outer join
3) self join

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I uninstall oracle 11g?

1113


If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2228


Can we save images in a database and if yes, how?

1058


What is set operator oracle?

971


What privilege is needed for a user to create tables in oracle?

951


What are the predefined tablespaces in a database?

1079


Explain oracle insert into command?

1110


6. Display the client name and order date for all orders using the traditional method.

2301


List out the components of logical database structure of oracle database.

1033


Explain table?

1109


Is the After report trigger fired if the report execution fails ?

2912


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1930


Explain what are the type of synonyms?

1106


Explain how are indexes update?

1060


Explain the types of exception?

1142