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
- 5311 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 |
how we transport universes from business objects 6.5 to BOXI R2?
How do u Receive requiremnts from the client?
I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.
suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?
Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.
how u restrict the values?to display 5 values insted of 10 values?
How many universes will run maximum in single project
what is mean by lov?
why we are using derived tables ?how it will help?
WHAT IS CARDINALITIES OF JOIN?
How will solve a loop caused by lookup table without using alias?
what happens if cardinalities are not resolved?
Teradata 
