in reply to joined records from multiple csv

The Data::Table module is useful for this kind of task. For an example of joining data from csv files, see Re: Merging two data sets, which is in reply to Merging two data sets. See the documentation for Data::Table and the Data Table Cookbook for more information.