Skip to Content
0
Former Member
Jan 15, 2007 at 01:31 PM

Join of queries

21 Views

Hello All

Can someone tell me how to join two queries without using a multicube

or infoprovider option.

First Query has x, y, z fields

Second Query has x,a,b fields

now can i join the first and second query by the common field x.

Without changing the infoprovider or multicube design,i want to join

the query at the query level.

I want to join the two queries using common field x and then replace

the second query a, b fields with y, z fields data of query1.

Regards