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
- 6253 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
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Difference between b.o 5.1 and 6.1b?
When we use aggregate awareness function in designer?
any difficulitis have you phase while creating bo reports and how did u solve it
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
Explain about a time when you discovered a more efficient way to do a work task?
How many universes can be created in a project?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
How to execute the plsql procedure from the report by clicking with mouse?
How to restrict password to a user while sending a document in .pdf format
Can we Save (save as) WEBI Doc as DESKI?
What is the difference between datawarehousing and businessintelligence?
Explain what three things do you consider to be the most important factors for a manager?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
