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

How to drop an index?

959


What do you mean by a deadlock?

1065


How do I uninstall oracle 11g?

1118


What is bulk copy or bcp in oracle?

1124


How to best split csv strings in oracle 9i?

1041


What is bind variable in oracle 11g?

1039


How to loop through a cursor variable?

1085


How to run queries on external tables?

1047


How to lock and unlock a user account in oracle?

1106


How to call a sub procedure?

1094


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1841


State and explain the different types of data models?

944


Compare and contrast between sql and sql server and explain its various functions?

964


Who developed oracle & when?

1003


Difference between varchar and varchar2 data types?

1184