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
Can you please send me the migration related issues .
Explain what is the difference between business requirement document and use case document.
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
What is object stores?
Give some information on report bursting?
What is thumbnail?
What is the functional & architectural differences between business objects and web intelligence reports?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
How can you first report in Business Objects by using broadcast agent?
What is the difference between user and versatile user?
Explain about alerts in bos, under what situation we need to use alerts?
what is the difference b/w the refresh and buffered data?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
How to execute the plsql procedure from the report by clicking with mouse?
