What is shortcut join?could give any one example?

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


Please Help Members By Posting Answers For Below Questions

Explain how to execute the plsql procedure from the report by clicking with mouse?

610


Can Bo generates the Report from the cubical data Explain?

1636


explain in detail about type 3?

637


What is package in BO

2700


What are the steps to do to use alerts in bo?

640






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 ?

1586


How to create Index to the table in the universe designer and how it improves the Query performence

2132


in sap bi we have wad, then why we go for sap bo

2786


Explain what are the steps to be taken to schedule the report?

657


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

1590


Explain how to schedule the report in b.o?

571


Explain what would you consider as your biggest achievement and why?

588


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

562


what are the day to day activities of BO administrator ?

1986


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2623