All,
I was wondering what is the best practice for handling joins in an Interactive Grid (IG)? I'm in the process of converting a bunch of legacy tabular forms to IG and I've found that the IG doesn't like to have joins in the SQL source. I've been removing the lookup tables and converting them to LOVs, but I've run into instances where there are multiple columns displayed from a single lookup table. In these cases, it seems inefficient to have to select multiple times from the same table/row for each column displayed. I was just wondering how others have handled this and if there's a better way.
@"John Snyders-Oracle"
Thanks,
Paul