Kiran,

This is a *Perl* site for *Perl* questions. In some cases the problem domain overlaps a little with Unix/Linux, Apache, SQL, mod_perl and networking areas of expertise -- that's OK. However, here you're asking us to write a complete answer, without having tried anything (well, anything that we can see here, anyways), and that's just not on.

It seems you want to generate some kind of report, based in some input files. Well, in broad terms, the solution is

• Read the data into some kind of hash or array data structure, making the appropriate connections between the data as necessary;
• Make further appropriate connections, possibly simplifying the data structure; and
• Dump out the data structure in some sort of suitable format.

So good luck with that.

And let us know when you have a Perl question that we can help with. ;)