Merge Datasets

HSMorales

I have 3 datasets that are created using 3 stored procedures. The 3 data sets have 1 common field. How can I create a forth data set that combines all 3 datasets??

Example:

The first dataset has fields Insurance_Name, Coverage_Opt, Coverage_Type

The Second data set has fields Insurance_Name, Insured Name

The Third data set has fields Insurance_Name, Level

In my detail I would like to list:

Line 1: Insurance_Name Coverage_Opt Coverage_Type
Line 2: Insured_Name Level


Insurance_Name may or may not exist in the second and third datasets.

Is there an easy way to do this ??


I am running BIRT version 3.7.0

Thanks