[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote:
> The SQL I would use is: > SELECT Names.Name, Names.Age, Ages.Description > FROM [Names] LEFT JOIN Ages ON Names.Age = Ages.Age; > > But DBD::CSV (that is, SQL::Statment) doesn't support the 'LEFT JOIN' > syntax. According to the docs, SQL::Statement does support left joins. http://search.cpan.org/~jzucker/SQL-Statement-1.14/lib/SQL/Statement/Syntax. pod#SELECT Perhaps you need to upgrade to the latest version of SQL::Statement. Ronald
