> SELECT *
> FROM MyTableWithDates
> WHERE datetime("now") > MAX(dtEndDate)
What is it that you are actually trying to do with this query? As
formulated (even if it were syntactically correct, which I don't think
it is), you are either going to get every row in the table, or no rows
at all. Since the current date ("now") is either greater than the
maximum date in the table, or it is not, and you're not comparing to a
column in each row, only the aggregate, the resulting condition will
either be true for every row in the table, or false for every row.
Brad
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
