Please Help - Missing Data !

[zincb]

Here is my problem:

Table 1 is SYSTEM.

Table 2 is COMPONENT.

Table 3 is BANDWIDTH.

A SYSTEM can have zero or many COMPONENTS.

A COMPONENT may have zero or many BANDWIDTHs.

I want to export all data from all tables, to a single flat file.

If I export with my "focus" on BANDWIDTH, I only get COMPONENTS that have a BANDWIDTH, and only SYSTEMS that have those COMPONENTS. So, to export the whole enchilada as a single flat file, I need to be on the SYSTEM table, to export all local and linked data.

The problem is that, in the export file, SYSTEM data is only in the first row of the export set. Each succeeding row contains data from COMPONENT, or both COMPONENT and BANDWIDTH, but does not contain the SYSTEM information.

This data, no-data, pattern is repeated for each SYSTEM record in the export file.

Because the SYSTEM data is not entered into the rows containing COMPONENT and BANDWIDTH information, I must run a looping script on the entire exported file, to copy the parent data into subsequent rows. With zillions of records this extra step is extremely time-consuming.

Is there something I can do to avoid this last step?