bonjour,Le mardi 25 mai 2004, Noah J SILVA a �crit... > UPDATE table1 > SET table1.field1=(SELECT field1 FROM table2 WHERE table1.key = > table2.key) Should be correct but...columnname to update must be specified without table name UPDATE MYTABLE SET MYCOLUMN="blah" -- jm -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
