Hi, I have trouble getting this query to qork in sqlite, in mysql it works but I can't get it to work in sqlite, I tried different things, aliasing table name, without alias, I googled first ofcourse but didn't found anything... Can somebody help, here goes sql:
SELECT COUNT(visitor_id) AS num_visits, human_year AS year, human_month AS month, human_day AS day, (SELECT COUNT(DISTINCT ip_address) FROM nm_visitors WHERE human_year = year AND human_month = month AND human_day = day) AS num_unique_visits FROM (nm_visitors) GROUP BY human_year, human_month, human_day ORDER BY date DESC LIMIT 20 And I get error: no such column day I tried various things that all works in mysql but I can't understand how sqlite handle this... = -- Powered by Outblaze _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
