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 how to execute the plsql procedure from the report by clicking with mouse?
Can Bo generates the Report from the cubical data Explain?
explain in detail about type 3?
What is package in BO
What are the steps to do to use alerts in bo?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
How to create Index to the table in the universe designer and how it improves the Query performence
in sap bi we have wad, then why we go for sap bo
Explain what are the steps to be taken to schedule the report?
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 how to schedule the report in b.o?
Explain what would you consider as your biggest achievement and why?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
what are the day to day activities of BO administrator ?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.