don't use the 'c' alias and it will run ok. -----Original Message----- From: Andris Spruds [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 1:25 PM To: [EMAIL PROTECTED] Subject: Question about UPDATE query syntax
Hello MaxDB list, I have problems understanding the correct syntax of a particular UPDATE statement. The query, which seems a pretty standard query for me, does not work: 'update ar_comments c set c.author = (select u.username from users u where u.id = c.author_id)'. It complains about '-5016 Missing delimiter:='. The query, however, executes just fine if 'c.author' is replaced with just 'author'. Is this a bug or more likely, it's just my wrong understanding of SQL? Best regards, Andris Spruds -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
