http://softtime.ru/forumhttp://softtime.ru/forum/read.php?id_forum=3&id_theme=64733#post376321спасибо!Operand should contain 1 column(s)Thu, 30 Apr 2009 16:07:51 +0300roninhttp://softtime.ru/forum/read.php?id_forum=3&id_theme=64733#post376320AND c.id_user IN (SELECTOperand should contain 1 column(s)Thu, 30 Apr 2009 16:01:34 +0300Roothttp://softtime.ru/forum/read.php?id_forum=3&id_theme=64733#post376319вот исправил, но выдает: Subquery returns more than 1 rowOperand should contain 1 column(s)Thu, 30 Apr 2009 16:00:24 +0300roninhttp://softtime.ru/forum/read.php?id_forum=3&id_theme=64733#post376317"AND c.id_user=(SELECT * FROM h_users WHERE block='0')" select должен вернуть одно значение, id например. UPDOperand should contain 1 column(s)Thu, 30 Apr 2009 15:43:53 +0300Roothttp://softtime.ru/forum/read.php?id_forum=3&id_theme=64733#post376304Здравствуйте! Подскажите в чем янеправ SELECT c.foto, c.company_id, c.id_user, u.id_user FROM h_company as c, h_users as u WHERE c.pay='1'...Operand should contain 1 column(s)Thu, 30 Apr 2009 13:23:44 +0300ronin