Joining Queries in the Table Interface
I have been tasked with determining how to join 2 queries into a single result, probably using the Table Interface Class to achieve this.
Apparantley this is possible, but I have yet to find any documentation on this and would appreciate any feedback.
It appears as though the requirement is to have 2 queries displayed in a single table (through the WAD). The first query would display normally in the table web item, and the table interface would hopefully be able to take the 2nd query and join it onto the table.
This is not just adding rows onto the table, but rather adding columns. 1 column from the first query would be used as a key to lookup the corresponding result in the second query, and populate the data accordingly.
Anybody seen something like this.
Any reference material?