I have a situation, in which I need to find the price range of a set of products. But, in this particular situation, I have multiple ranges that depend on the article Group.
I have multiple tables like this one, that differ in their name only:
They all may have totally different ranges, and therefore the intervals' limits. They are saved into individual QVD files.
Then I have only one table that looks like this one:
I've already tried a solution having only one range table, and it works right. I can't manage to make it work having multiple range tables.
LOAD distinct Inf, Sup Resident Ranges;
I found this solution somewhere in this forum, and it worked just fine, for that scenario. Maybe someone could help me modify it, so that I can reach my goal.
Thanks in advance!