Re^4: DBI INTERVAL Error

Why wouldn't this work with the code sample you posted?

my $sql = " SELECT * 
              FROM
                 ( SELECT name, city, COUNT(*) AS Rows 
                  FROM file.csv
                  WHERE ( mydate >= ? ) 
                  AND  ( mydate   < ? ) ) t1 
              INNER JOIN
                 ( SELECT name, city, COUNT(*) AS Rows 
                   FROM file.csv 
                   WHERE ( mydate >= ? )
                  AND ( mydate < ? ) ) t2 
              ON t1.mydate = t2.mydate";
[download]

From here:
http://search.cpan.org/~jzucker/SQL-Statement-1.14/lib/SQL/Statement/Syntax.pod

Docs:
Explict Join Qualifiers: NATURAL, INNER, OUTER, LEFT, RIGHT, FULL
Any thoughts?

Comment on Re^4: DBI INTERVAL Error Download Code

Replies are listed 'Best First'.
Re^5: DBI INTERVAL Error by poj (Abbot) on Mar 20, 2016 at 20:35 UTC
Where does it mention support for subselects ? If you have 2 date ranges then try `my $sql = "SELECT name, city, COUNT(*) FROM file.csv WHERE ((mydate >= ?) AND (mydate < ?)) OR ((mydate >= ?) AND (mydate < ?)) GROUP BY name,city ";` [download] poj	[reply] [d/l]