Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajasekhar
hi,
The joins are two types... the first one is equi-join that
is using of = symbol.for example we have two tables called
wmp and dept. in emp we have deptno object. the same object
we have dept table also then we can create like this:
emp.deptno = dept.deptno.
The non-equijoin is with out same object from the both table
by using between keyword. we can take the bellow example
like emp(empno,sal) and salgrade(grade, lesssal,highsal) we
can create join from the aboue table like this: where sal
between lesssal and highsal.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What three things do you consider to be the most important factors for a manager?
What is the dense rank?
Did you face any problems while creating reports? Name? Solutions?
is it possible to export the webi reports to crystal reports?with out using businessview?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Difference between b.o 5.1 and 6.1b?
how to prepare the documentation in business objects and where to get the requirement?
what is the difference b/w the refresh and buffered data?
Explain when we use aggregate awareness function in designer?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
8. How much supervision have you typically received in your previous job?
What is the difference between datawarehousing and businessintelligence?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
