What is the best way to build data block?

From: <suisum_at_ecn.ab.ca>
Date: 16 May 99 05:44:19 GMT
Message-ID: <373e5b33.0_at_ecn.ab.ca>

What is the best way to build data block? I have table structure as follows. Please help out how I can display the two Sets records as well as the assoicate children records?

Thanks,

  SCENARIOS

---

  Scenario_ID NUMBER
  Name VARCHAR(10)

  1 Scenario has TWO sets.

  SETS

---

  Set_ID NUMBER
  Scenario_ID NUMBER

  Name        VARCHAR(10)
  Amount      NUMBER

  1 Set can have many ranges.

  RANGES

---

  Set_ID      NUMBER
  range1      NUMBER
  range2      NUMBER
  range3      NUMBER

I need to display data as follow layout:

+-------------------------------------------+


| Scenario ID: XXXXXX                       |


| Name       : XXXXXXX                      |


+-------------------+-----------------------+


| Set 1             | Set 2                 |

| -----             | -----                 |

| Set Name: XXXX    | Set Name: XXXX        |


| Amount  : 99999   | Amount  : 9999        |


+-------------------+-----------------------+


| Rng1 Rng2 Rng3    | Rng1 Rng2 Rng3        |

| 999  999  999     | 999  999   999        |

| 999  999  999     | 999  999   999        |

| 999  999  999     | 999  999   999        |


| 999  999  999     | 999  999   999        |


+-------------------+-----------------------+

--
Best regards,

Received on Sun May 16 1999 - 07:44:19 CEST