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

Joins allows you to read or report the data from more than 1 table. There are four types of joins are there..
1) equi join or inner join or natural join
2) non equi join
3) outer join
a)left outer join
b)right outer join
c)full outer join
4) self joins

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2302


How to load excel data sheet to oracle database

967


How do I connect to oracle database?

1028


Explain what are the different type of segments?

914


What is an oracle function?

1074


what is difference between sql plus and sql*plus? (not sql and sql plus).

3814


List out the difference between commit, rollback, and savepoint?

987


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

1071


How to get execution statistics reports on query statements?

1009


What is bind variable in oracle 11g?

995


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

2241


What is the scope of a local variable?

998


What are the roles of dba?

1020


What are nested tables?

1107


What would you do with an in-doubt distributed transaction?

1915