Framework Manager Joins

[CognosTalk]

I've created a query subject that converts table rows into columns. I used sql statements for this conversion. How this query subject can be connected with another query subject in cognos, since it is only distinct rows from another table. What can i specify inside the join.

 

[blom0344]

Your de-normalized structure will yield a set with it's own primary key, I guess (a virtual key in this case).
Can you post the SQL in any case. Should be interesting in any case.

Ties Blom