Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7897 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vishal
select a.empid, a.name, a.deptno from table1 a, table2 b where a.deptno != b.deptno
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
Give some information on report bursting?
Differences between business objects and web intelligence reports?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain is there any default username & pwd for bo designer & supervisor?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Explain in detail about type 1?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
what is document design in boxi,have u participate in that
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What is the difference in creating filters in designer and business objects?
what is universe null
Which versions are used in the bo dashboard work?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
how to create reports on screech?
