I am trying to get Zone and Percentage for a specific Device and time. That is I am matching Interval Device and Time with Time Interval to get its Zone and Percentage. The Device can be connected to multiple devices with percentage allocated. But it is working fine with single row but as soon as there are x-squared lines to one interval there is x duplication of lines in end result. For example I have made 3 Zones for a specific interval so there are 9 lines instead of 3 lines.
Can anyone help to eliminate the extra rows or alternate solution