At 21:03 +0100 3/27/02, Javier Armendáriz wrote: >Can someone tellme the problem in this query?????? > >Is there any problem updating two tables in the same query???
Do you find that syntax to be allowed anywhere in the MySQL manual? There is work on this kind of thing being done for MySQL 4.1. It's not ready yet. > >update alumno, alumnocurso >set >alumno.nombre='Blas', >alumno.apellidos='Martinez Maertinez', >alumno.nacimiento='1990-09-12', >alumno.telefono = '666666666', >alumnocurso.incorporacion = '2002-3-16', >alumnocurso.finalizacion='0000-0-0', >alumnocurso.observaciones = 'Observaciones id 4' >where alumno.id = '4' >and alumnocurso.id = '4' >and alumno.id = alumnocurso.id_alumno ; --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
