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
- 6394 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 |
Can we Save (save as) WEBI Doc as DESKI?
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?
What is the local filter and global filter in bo's?
When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?
Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.
what is prompt? Cascading prompt? Syntax
What are @FUNCTION?
how do we apply sql query on selected variables?
if we shortcut join between two tables what will be the output?that it will give all columns or same columns?
what is variable ?
Instead of cms which server you have to use?
Teradata 
