Business Objects Question:
Explain the difference between union and group?
Answer:
The difference between union and group is as follows:
take two tables t1 and t2.
in t1 we have columns like a,b,c,d. and t2 has a,d,e,f.
so union means t1 union t2 i.e getting result from both tables i.e a,b,c,d,e.,f
where as group performs on a individual column in a particular table.
take two tables t1 and t2.
in t1 we have columns like a,b,c,d. and t2 has a,d,e,f.
so union means t1 union t2 i.e getting result from both tables i.e a,b,c,d,e.,f
where as group performs on a individual column in a particular table.
| Previous Question | Next Question |
| What is top business? | Explain What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue? |