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
- 6369 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 to test reports in businessobjects?
I have very Latest Business Objects-XI Certification Dumps for all the Codes, If anyone need, mail at: AJITH.BOXI@GMAIL.COM
What are all difference between business objects 6.5 and xi r2?
What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?
What is meant by data federator and what is the use of it?
please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.
how to optimize the query perfomance in b.o?
when we go for snow flake schema rather than star schema ?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
how do you share the universe ?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
9.what are the multidimensional analyses
Teradata 
