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 / shree

In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join
In Oracle server
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins

Is This Answer Correct ?    47 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of constraints option in exp command.

1083


Explain the use of log option in exp command.

1186


In the oracle version 9.3.0.5.0, what does each number shows?

1346


How to drop an existing table in oracle?

1104


How to apply filtering criteria at group level in oracle?

1086


Explain alias?

1193


Is it possible to insert comments into sql statements return in the data model editor ?

2638


What happens to the current transaction if the session is ended?

1137


How to install oracle odbc drivers?

1145


What are the database administrators utilities available?

1096


How to define a data field as not null?

1163


how can we store any pdf file in oracle

2222


Who developed oracle & when?

1059


What are the oracle built-in data types?

1138


How to work with data objects interactively?

1043