How Can Queries Be Combined And What Is The Use?

1.	How Can Queries Be Combined And What Is The Use?
Answer» You can combine queries in three relationships: Union INTERSECTION Minus In a union combination, Web Intelligence takes the all the DATA from both queries, eliminates duplicate ROWS, and builds a COMBINED data set. In an intersection combination, Web Intelligence returns the data that is common to both queries. In a minus combination, Web Intelligence returns the data in the first query that does not appear in the second. You can combine queries in three relationships: In a union combination, Web Intelligence takes the all the data from both queries, eliminates duplicate rows, and builds a combined data set. In an intersection combination, Web Intelligence returns the data that is common to both queries. In a minus combination, Web Intelligence returns the data in the first query that does not appear in the second.

Answer»

You can combine queries in three relationships:

In a union combination, Web Intelligence takes the all the DATA from both queries, eliminates duplicate ROWS, and builds a COMBINED data set.

In an intersection combination, Web Intelligence returns the data that is common to both queries.

In a minus combination, Web Intelligence returns the data in the first query that does not appear in the second.

You can combine queries in three relationships:

In a union combination, Web Intelligence takes the all the data from both queries, eliminates duplicate rows, and builds a combined data set.

In an intersection combination, Web Intelligence returns the data that is common to both queries.

In a minus combination, Web Intelligence returns the data in the first query that does not appear in the second.

Discussion