you have two tables table 1 contains emp id,name and deptno
and tble 2 contains only depatment number some of the
depatment no of 1st table are not present in table 2 how
will you create a report only to get the departments of
which excess in table 1
- 4 Answers
- 6388 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar
select empid,name,depno from table1,table2 where
table1.deptno not in table2.deptno
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
When we use aggregate awareness function in designer?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
How can you first report in Business Objects by using broadcast agent?
What is the difference in creating filters in designer and business objects?
What is the difference between user and versatile user?
Explain the difference between union and group?
What are the steps to do to use alerts in bo?
What is the difference between slice and dice and cross tab report?
Difference between zabo and webi?
what is universe null
Difference between b.o 5.1 and 6.1b?
Can more than 1 metric be applied on an analytic in business objects?
Did you face any problems while creating reports? Name? Solutions?
What is the dense rank?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
