in reply to many to many join on text files

Yup. Use a real database. DBD::SQLite and DBD::Pg both come to mind immediately.

-- Randal L. Schwartz, Perl hacker
Be sure to read my standard disclaimer if this is a reply.

In Section Seekers of Perl Wisdom