subquery, returns more than one filed?

[Jerry Swanson]

Can subquery return more than one column in Mysql 4.1.7?

SELECT (select user.last_name, user.first_name from actor where
user.id=6) as last_name, first_name
  (select count(*) from account where account.status = 'progress') as
progress_count,


ERROR 1241 (21000): Operand should contain 1 column(s)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]