List:General Discussion« Previous MessageNext Message »
From:Jerry Swanson Date:January 13 2005 7:38pm
Subject:subquery, returns more than one filed?
View as plain text  
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)
Thread
subquery, returns more than one filed?Jerry Swanson13 Jan
  • Re: subquery, returns more than one filed?Gleb Paharenko14 Jan