John Brooking wrote:
> Also one last question (AFAIK) about what is > supported: See the pod documentation in SQL::Parser for a description of what SQL is supported in DBD::CSV. > What about GROUP BY No, not yet supported. > and standard grouping > functions such as SUM and COUNT? Supported in the SELECT clause (e.g. SELECT COUNT(*) FROM ...) but not supported yet in other clauses. > my $parser = SQL::Parser->new('Ansi'); > $parser->feature( 'select', 'join', 1 ); No, forget that, DBD::CSV handles that for you. If you are using the new SQL::Statemetn 1.x then joins are automatically enabled and you can just pretend that SQL::* modules don't exist since DBD::CSV calls them for you behind the scenes. > C>perl runSQL.pl "SELECT S.Title, P.PerfDate FROM > Shows S, ShowTimes P WHERE P.ShowID = S.ShowID" There's currently a bug in dotted table names, try an explicit join with a USING or ON clause. I hope to have the dotted table names thing fixed in the next couple of weeks. -- Jeff