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

Please explain the difference between outer join and inner
join? With examples would be appreciable..!

Answer Posted / ashish sajwan

In Inner join the result is show only the matching columns which are common in both tables,In outer join the results show matched and unmatched columns from both tables

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load data from external tables to regular tables?

1060


What are the different types of trigger and explain its various uses and functions?

1085


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1083


What is the data pump import utility?

1029


How to retrieve data from an explicit cursor?

1054


What are transaction isolation levels supported by oracle?

1062


What is raw datatype in oracle?

1128


How to work with data objects interactively?

974


Can multiple cursors being opened at the same time?

1056


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2364


What is Reduced List of Values?

2160


What is an oracle database table?

1009


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2094


How would you change old and new values in an insert, delete and update triggers?

1014


HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2493