Hi,
I would really appreciate it if someone could help me create a flat file
from a couple of relational tables.
Emp_Info = Employee_id along with name & address info
Emp_Depend = Empolyee_id, Dep_id , lastname, firstname, birthdate (employee's
children)

I need to create one record per Employee that would contain some employee
info along with the names & birthdates of their children.

Would I create a Table_emp_dep in the format that I need, load it with the
Emp_Info data first and then update it with the Emp_Depend data that I need?


Emp_id
Emp_last
Emp_first
Child1_lastname
Child1_firstname
Child1_birthdate
Child2_lastname
Child2_firstname
Child2_birthdate ....and so on for as the most children an employee has.

In sql, how do I set it up to loop through the Emp_Depend file and choose
the records that I need and write them to the specific fields that they correspond
to?

If this is the correct approach, please include example of actual code that
works.

Thank in advance,
Sue