Creating a flat file
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
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?
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
If this is the correct approach, please include example of actual code that
Thank in advance,
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center