OK, this makes my day clear!! I have versión 3.23.49-3 of MySQL Thanks Dwight! -----Original Message----- From: Dwight Altman [mailto:dwight@xxxxxxxxxxxx] Sent: Jueves, 28 de Septiembre de 2006 11:32 a.m. To: php-db@xxxxxxxxxxxxx Subject: RE: SQL query Check your version. Subselects were only added in MySQL Version 4.1. Regards, Dwight > -----Original Message----- > From: Edwin Cruz [mailto:ecruz@xxxxxxxxxxxx] > Sent: Thursday, September 28, 2006 10:53 AM > To: 'Miguel Guirao'; php-db@xxxxxxxxxxxxx > Subject: RE: SQL query > > Make sure that your second query is returning only one row, if it dont > help, try this: > $query="select email from usuarios where userName in (select username > from fussv where folio = 'FUSS-130-2006')" > > > MySQL think that you second query returns more than 1 row, that's why > mysql dont accept your query, is like trying to compare vs more than one > scalar value > > Regards! > > +----------------------------------------+ > | Ing Edwin Cruz <ecruz@xxxxxxxxxxxx> | +----+ > | Transportes Medel Rogero SA de CV | | | > | Desk: +52 (449) 910 30 90 x3054 | +----+ > | MX Mobile: +52 (449) 111 29 03 | > | Aguascalientes, Mexico | > | http://www.medel.com.mx ; | > +----------------------------------------+ > > > > > -----Mensaje original----- > > De: Miguel Guirao [mailto:miguel.guirao@xxxxxxxxxxxxxxx] > > Enviado el: Jueves, 28 de Septiembre de 2006 09:09 a.m. > > Para: php-db@xxxxxxxxxxxxx > > Asunto: SQL query > > > > > > > > > > Hello list, > > > > Whats wrong with my SQL query: > > > > $query="select email from usuarios where userName = (select > > username from fussv where folio = 'FUSS-130-2006')"; > > > > I get an error! > > I have tested the two individual sentences and they worked OK! > > > > --------------------------- > > Miguel Guirao Aguilera > > Logistica R8 TELCEL > > Tel. (999) 960.7994 > > > > > > Este mensaje es exclusivamente para el uso de la persona o > > entidad a quien esta dirigido; contiene informacion > > estrictamente confidencial y legalmente protegida, cuya > > divulgacion es sancionada por la ley. Si el lector de este > > mensaje no es a quien esta dirigido, ni se trata del empleado > > o agente responsable de esta informacion, se le notifica por > > medio del presente, que su reproduccion y distribucion, esta > > estrictamente prohibida. Si Usted recibio este comunicado por > > error, favor de notificarlo inmediatamente al remitente y > > destruir el mensaje. Todas las opiniones contenidas en este > > mail son propias del autor del mensaje y no necesariamente > > coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna > > de sus empresas controladas, controladoras, afiliadas y > > subsidiarias. Este mensaje intencionalmente no contiene acentos. > > > > This message is for the sole use of the person or entity to > > whom it is being sent. Therefore, it contains strictly > > confidential and legally protected material whose disclosure > > is subject to penalty by law. If the person reading this > > message is not the one to whom it is being sent and/or is not > > an employee or the responsible agent for this information, > > this person is herein notified that any unauthorized > > dissemination, distribution or copying of the materials > > included in this facsimile is strictly prohibited. If you > > received this document by mistake please notify immediately > > to the subscriber and destroy the message. Any opinions > > contained in this e-mail are those of the author of the > > message and do not necessarily coincide with those of > > Radiomovil Dipsa, S.A. de C.V. or any of its control, > > controlled, affiliates and subsidiaries companies. No part of > > this message or attachments may be used or reproduced in any > > manner whatsoever. > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
