Hi all,
I have some 5 views created with me, my job is to pass these to an XML
stylesheet. The views have a common key that can be used to take a join on
all 5. But the problem is that for 4/5 views the common key has more than
one entry in the view-table.
eg
View A View B View C ..
K1 A1 K1 B1 K2 C1
K1 B2
K1 B3
K2 A1 K2 B1
In the views B,C,... the common key can have 0 or more values. I need to
print a report that has the common key K1 and rest of the values picked
from the remaining tables. I believe this should be possible just struggling
would appreciate all kinds of help.
Thanks
Sid
