What is a join? Explain different types of joins?

Answer Posted / subhash

Join is used to link to tables depending upon the data
requested by the user, Usually we have Inner Join, Outer
Join, Left Join, Right Join, Full Outer join.

Is This Answer Correct ?    14 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1749


Explain difference between zabo and webi?

656


Can we create universe with no cache??

1960


What are all difference between business objects 6.5 and xi r2?

607


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

602






BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1725


How to restrict password to a user while sending a document in .pdf format

1865


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

818


How were the reports scheduled and how to resolve unexecuted documents?

2223


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

1433


Explain about a task that really tested your analytical abilities?

760


what is document design in boxi,have u participate in that

1663


What is Indexing? how did u implement indexing?

1820


What is difference between webi and infoview?

619


What is report template in b.o?

588