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

CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?

2 Answers  


HI ALL, CAN ANY PLEASE TELL ME HOW TO CREATE HYPERLINKS IN WEBI.THANKS IN ADVANCE

2 Answers  


what is meant by report busting

2 Answers   TCS,


2.What is loop? How resolve the loop?explain it?

11 Answers   TCS, UHG,


can anybody explain me in detail about software development life cycle of business objects in detail?

1 Answers  






What is BOMain.Key?

5 Answers   Cognizant,


What three things do you consider to be the most important factors for a manager?

0 Answers  


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

1 Answers  


I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps

17 Answers   IBM,


There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 Answers  


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

0 Answers   iNautix, Wipro,


what is the difference between input file repository server and output file repository server ?

2 Answers   CTS,


Categories