after upgrade to 4.1 - error in multi delete

[Merlin Morgenstern]

Hi there,

I have recently upgraded from mysql 4.0 to 4.1.x

Now I am facing an error while issuing this delete command:

   # delete report images in db
   $stmt= "
       DELETE
       FROM
           $DB.$T21
       USING
           $DB.$T21 AS rp,
           $DB.$T13 AS r
       WHERE
           r.ID = rp.recommendations_id
           AND r.user_recommending = '$user_id'
   ";

Error: 1109 Unknown table 'the_table_name' in MULTI DELETE

Has there something changed in the syntax?

Thank you for any help,

Merlin

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]