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
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain what task is 98% of the required work of a business analyst?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain is data mart?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
how to create reports on screech?
How to execute the plsql procedure from the report by clicking with mouse?
What is the difference in creating filters in designer and business objects?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What are all difference between business objects 6.5 and xi r2?
What task is 98% of the required work of a business analyst?
Can anybody tell me what are the tuning problems?