Move from union to union
661894Oct 8 2008 — edited Oct 9 2008Hello all!
I have this data hierarchy:
name-> subname
I make in BI Answers that table:
name par1 par2
... ... ...
(COLUMN par1 and par2 is different subquery and result is a cross table of union of this 2 query)
After that I want in case user click on NAME value hi go to table like this:
subname par1 par2
... ... ...
(COLUMN par1 and par2 is different subquery and result is a cross table of union of this 2 query)
And subname was connect to NAME that user click.
When 1 Answer is 1 Query I just add in second answer filter of column NAME and all use correct, but when 1-st and 2-nd Answer is UNION everything NOT use.
If you know how can I do it, PLEASE HELP ME.