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 anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
database tables.

Answers were Sorted based on User's Feedback



please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and..

Answer / punnaiahbabu

Equi join means equlity condition b/w tables
left outerjoin :matching and unmatching from left side onley
matched from right side.........
right outer join:matching and unmatching from right side
onley matched from left side.
outer join :matching and unmatching displed both of the tables
self join:we will right on sql query on the table.

Is This Answer Correct ?    7 Yes 0 No

please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and..

Answer / babu

Equai join: Matching records based on equality condition is
satisfied in the both the tables.
Left puter jion:All Records from left table only matcning
records form right table.
Right outer join:All records from right table and only
mating rows from left table.
theta join:Mating the records based on other than the
euality(ex:Age,Marks)
Self Join:It's a join with itself is called self join

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Business Objects Interview Questions

Difference between scope of analysis in webi and in deski?

1 Answers   CA,


How many universe dfi you create if you have 2 years of experience in BO

6 Answers   IBM,


How would I achieve Traffic Lighting in Business Objects

3 Answers   Virtusa,


Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.

1 Answers   TCS,


every reports have docid,when i export a report docid will change or not?

4 Answers   Zensar,


Aliases and Contexts Which once will give the better performence when resolve the loops?

3 Answers   HCL,


Who launches the supervisor product in Business Objects for first time?

2 Answers  


Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

1 Answers   IBM,


How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.

1 Answers   Oracle,


date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2

1 Answers   Honeywell,


When we are going for Shortcut join and why.

1 Answers   Cap Gemini,


Explain the data types present in bo and what happens if we implement view in the designer and report?

0 Answers  


Categories