Hello.
Starting with MySQL 4.1, all subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. You use subquery in a wrong way. See: http://dev.mysql.com/doc/mysql/en/Subquery_errors.html Jerry Swanson <[EMAIL PROTECTED]> wrote: > 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) > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
