Creating Queries

What is the difference between using UNION QUERY and ADD QUERY (TAB)? Can you not combine results similar to a UNION QUERY by ADDING QUERY TABS and merging the dimensions?


ANIVID (BOB member since 2009-09-12)

In relation to the above question, when is it advantageous to use UNION QUERY vs having mutlple query objects with merged dimension? And vice versa?


ANIVID (BOB member since 2009-09-12)

A union merges the data in rows (vertical) fashion. Adding a query and joining (merging) adds new columns (horizontal). The two techniques are not substitutes for each other.


Dave Rathbun :us: (BOB member since 2002-06-06)

Thank you!


ANIVID (BOB member since 2009-09-12)