What is self join

Answer Posted / nitish

A table is joining to itself is called as a self join let us take an example of there is a table emp and dept, the user want to analyse the report how many employees are working in a particular dept

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between slice and dice and cross tab report?

609


Explain about a tricky situation for which you found a very simple solution?

545


Is there any other repository domains rather than universe, security, document?

604


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

4455


What are the join problems comes appart from loop,chasm & fan Traps

1558






What is package in BO

2687


What is the difference between absolute and relative div positioning?

588


can anybody tell me about complicated object you have created

2759


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1691


how to prepare the documentation in business objects and where to get the requirement?

1789


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2611


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3002


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

939


Differences between business objects and web intelligence reports?

660


Which versions are used in the bo dashboard work?

603