Can any one please explain difference in combined query and subquery or where I can find the information on this.
Ratna
ratnavis (BOB member since 2008-04-18)
Combined queries are multiple queries on the same universe that return a single set of data.
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.
A subquery is a more flexible kind of query filter that allows you to restrict
values in more sophisticated ways than with an ordinary query filter.
Subqueries are more powerful than ordinary query filters for the following
reasons:
They allow you to compare the values of the object whose values are
used to restrict the query with values from other objects.
They allow you to restrict the values returned by the subquery with a
WHERE clause.
refer xir2_wi_jrp_en.pdf for more details
paryaniafroze 
(BOB member since 2006-09-29)
meutte 
(BOB member since 2007-12-06)
Hi,
May you please explain in more details in which case we should use combined query function? What is the difference between the combined query function and if I just use ‘Or’ ‘And’?
Thanks
linelorhigh (BOB member since 2016-09-14)
Hi,
This can provide quite a good general overview:
Marek Chladny 
(BOB member since 2003-11-27)