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...

various types of joins

Answer Posted / s. senthil kumar

There are Two Types of joins:

I. Inner Join
II. Outer Join


I: Inner join:a) Equi join, b) Non Equi join c) self join
II: Outer join: a) Left outer join, b) right outer join,
c) Full outer join

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create tables for odbc connection testing?

1117


Explain about functional dependency and its relation with table design?

1010


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2008


candidate key is subset of super key but not vice-verse explain

2069


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


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2009


How to check your oracle database 10g xe installation?

988


What is program global area (pga) in oracle?

1030


Are truncate and delete commands same? If so why?

1156


Can we call procedure inside function in oracle?

1097


Explain compound trigger in oracle?

1040


What is where clause in oracle?

1031


Can we convert a date to char in oracle and if so, what would be the syntax?

1016


What do you mean by group by clause?

1045


When system tablespace is created?

1042