Joining queries in report

[Deepika]

Hi

I have 3 different queries.
Query 1:Group2,Group1,units and dollars
Query 2:Group2,Group1,units dollars
Query 3:Group2,Group1,units dollars

I want to join all the 3 queries in 1 query as I need all the 6 measures (Units and dollars from 3 different queries in one query)

For query 2 and query 3 queries,There are 2 separate query subjects in the package and I have Item code but the item code that exists in 2 need not necessarily should exist in 3.

For query 1,there is other query subject in the package and there is no item code in this query subject.

Now i need to include all the 6 measures (units and dollars) in one query as i need to do some calculations on the measures.
Can anybody explain in detail how is it possible to achieve

[raro]

Why don't you use the union element from the insertable objects pane "toolbox"?