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

What is shortcut join?could give any one example?

8 Answers  


define universe parameters?

5 Answers  


HOW DO YOU SCHEDULE THE REPORTS?

5 Answers  


i want to hide a chart in reporting level? i want to hide a prompt in designer level?

1 Answers   TCS,


I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?

2 Answers   Rolta,






1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?

1 Answers   iGate,


how we transport universes from business objects 6.5 to BOXI R2?

3 Answers  


what is main functional differences between BO and COGNOs?

5 Answers   TCS,


What is the difference between Thin client & thick client?

5 Answers  


is it possible to export the webi reports to crystal reports?with out using businessview?

0 Answers   TCS, CTC,


CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?

0 Answers  


Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?

2 Answers  






Categories