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
- 5309 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
What is the functional & architectural differences between business objects and web intelligence reports?
How to execute the plsql procedure from the report by clicking with mouse?
Explain the difference between detect alias and detect context?
What would you consider as your biggest achievement and why?
What is the dense rank?
What are all difference between business objects 6.5 and xi r2?
What are the steps to do to use alerts in bo?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
how get the grand total in master-detail report?
How can you first report in Business Objects by using broadcast agent?
what is universe null
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
What is the difference between absolute and relative div positioning?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Explain how many universes can be created in a project?
