Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6409 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski
what is master-detail report
What is Designer?
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
How will you move reports from Dev to QA in BO
How to restrict the user to refresh or Run the report only 1 time in BO?
bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?
What are the difference between merge,auto merge and extended merge ?
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.
IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me
how to connect one to one report? Explain with example?
Teradata 
