the function max(), among others, makes no sense in the absence of a
GROUP BY clause.
try adding "GROUP BY user_id"
- michael dykman
On Sun, Nov 8, 2009 at 9:40 AM, John Meyer
<johnme...@pueblocomputing.com> wrote:
> I want to get a list of all users who haven't posted in a week. But when I
> use the following function.
>
>
>
> select user_id, max(tweet_createdat) from tweets where
> datediff(now(),max(tweet_createdat)) > 7;
>
>
>
>
>
> Is producing the error:
>
>
>
> Invalid use of group function
>
>
>
>
>
>
--
- michael dykman
- mdyk...@gmail.com
"May you live every day of your life."
Jonathan Swift
Larry's First Law of Language Redesign: Everyone wants the colon.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
