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]
