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 is Outerjoin?

Answer Posted / rakesh

By using outer join we have to display both the matching and non matching records from both the sides(tables).

and in this we have three conditions
left,right and full outer joins.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

write a query to display the departments with no employee?

1971


what are the features in cognos8ui

2058


5. Which type of report you build more, list, crosstab or chart and why?

2020


Explain is there any comparison available for cognos reportnet vs crystal reports?

966


Write various indexes used in cognos?

973


Define cognos report net?

977


Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

2114


What is the advantage of using shortcuts?

1190


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11752


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2767


What is looping and how to avoid it in framework manager?

1211


Why is auto-regression used in forecasting used on cognos platform?

1022


what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

2080


What are the types of security?

1030


is there any difference between operational database and data base?if yes what r they?

2073