Hi, I've got an error message from MySQL 5.0 that I don't understand.
UPDATE "message_revision" SET "HasData" = 1, "Data" = (SELECT "Data" FROM "message_revision" WHERE "MessageId" = 7 AND "RevisionNumber" = 5) WHERE "MessageId" = 7 AND "RevisionNumber" = 6
SQL error: [SQLSTATE:HY000, 1093] You can't specify target table 'message_revision' for update in FROM clause
What went wrong? -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]