in reply to How do I... Do relational DBI joins using 2 (or more) flat file data sources
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.
|
|---|