please anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
database tables.
- 2 Answers
- 5338 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Explain how many universes can be created in a project?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain is data mart?
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
What is the dense rank?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is the difference between the public object&schema object?
What is top business?
What are the data types present in bo? What happens if we implement view in the designer and report?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What is the difference between datawarehousing and businessintelligence?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
8. How much supervision have you typically received in your previous job?
