Hi, I need to export 2 table information to single fixed length flat file structure (fixed length is maximum length of both the table). There would be a field which would specify the data is from which table. Although from top it sound simple as append the file directly from table.. but it is not. Because the two table that I want to export to single file has parent child relationship and the way record should appear is that one record of parent then all records of child for that parent and so on.. I am stuck at very begining as what is the way to proceed. One way which I am thinking is to create a temporary table which would hold the field definition of all and populate this table using normal SQL statement and then transfer to flat file. But seems very basic. Any other suggestions. Thanks and regards, Nilay.