Formatting a subquery?

[Brian Dunning]

I can't get MySQL 5 to like this query. Can you tell what I'm trying  
to do, and is there a problem with my formatting?

select account_id,picture_id from pictures where account_id in
(select account_id from accounts order by rand() limit 20)
order by rand();
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]