What is a join? Explain different types of joins?

Answer Posted / srinu

Combining a data from multiple tables is called join.
There r 5 types of joins r there.
1)Simple join 2)Equi join 3)Outer join 4)Theta join
5)Short cut join

Is This Answer Correct ?    4 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

690


what are the tables used in health care domain project and columns used in report?

4035


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9426


What is the difference between condition & filter?

605


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3843






Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

550


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1430


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

537


What is the difference between the public object&schema object?

570


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

599


How to open a universe with out using the Designer ??

6605


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

1815


Explain the difference between union and group?

622


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

587


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

679