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

Explain about alerts in bos, under what situation we need to use alerts?

643


Difference between zabo and webi?

749


What is the difference between business requirement document and use case document.

665


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

707


What is package in BO

2800






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

1869


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

4131


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?

1868


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

703


in sap bi we have wad, then why we go for sap bo

2884


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1695


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

2324


how to create metric universe ?

1997


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

1529


How to schedule the report in b.o?

651