On 15 December 2010 19:43, Jamal Soueidan <[email protected]> wrote: > But this gives me some weird error.
It's not "weird" - it's perfectly normal.... > select avg(url_count) from ( select count(url_id) as url_count, user_id > from urls_users group by url_id limit 10 ); > > ERROR 1248 (42000): Every derived table must have its own alias "AS tablename" - read a SQL reference! -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
