in reply to How do I... Do relational DBI joins using 2 (or more) flat file data sources

From the DBD::AnyData documentation:
Currently only a limited subset of SQL commands are supported. Only a single table may be used in each command. This means That there are *no joins*, but see the section above on simulating joins.
and
DBD::AnyData does not currently support using multiple tables in a single SQL statement. However it does support using multiple tables and querying them separately with different SQL statements. This means you can simulate joins by creating two statement handles and using the values from the first handle as a lookup key for the second handle.

I hope this helps. For more detail, see the documentation.

Impossible Robot
  • Comment on Re: How do I... Do relational DBI joins using 2 (or more) flat file data sources