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
- 5330 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / babu
Equai join: Matching records based on equality condition is
satisfied in the both the tables.
Left puter jion:All Records from left table only matcning
records form right table.
Right outer join:All records from right table and only
mating rows from left table.
theta join:Mating the records based on other than the
euality(ex:Age,Marks)
Self Join:It's a join with itself is called self join
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain about a tricky situation for which you found a very simple solution?
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:
What is thumbnail?
When we use aggregate awareness function in designer?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain how to execute the plsql procedure from the report by clicking with mouse?
how many reports have u created ? explain a few.
What are all difference between business objects 6.5 and xi r2?
What is the difference between datawarehousing and businessintelligence?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain what are the measure objects?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
how to prepare the documentation in business objects and where to get the requirement?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
how get the grand total in master-detail report?
