Hi Badd,

I think what you are referring to is a join between two flatfiles. DBD::CSV doesn't provide the mechanism to do this, so you would have to write one yourself. Essentially, get the result set from flatfile#1, store it in a hash, get the result set from flatfile#2, store it in a hash. Compare the two hashes to produce the data set you want.

This is where you have to weigh whether to stick with flatfiles or go with a more feature rich dbms. Which to choose depends on many criteria but if the flatfiles will wor for you, then you might as well stick with it else you will have to learn SQL - not altogether bad, but it is something more. ;-)

Jason L. Froebe