I had a working query that suddenly doesn't work anymore. It follows the syntax found in the documentation at
http://dev.mysql.com/doc/mysql/en/DELETE.html specifically, DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.id=t2.id AND t2.id=t3.id; my query is: DELETE FROM rsrc_linx_specialty USING rsrc_linx_specialty rls, rsrc_linx rl, rsrc_linx_type rlt WHERE rls.specialtyID = '$specialtyIDd' AND rls.sectorID = '$sectorIDd' AND rls.linxID = rl.linxID AND rl.linxID = rlt.linxID AND rlt.typeID = '2'; I'd been using this query successfully for a while. Then we upgraded to 4.0.17 and now it doesn't work neither from a PHP page, nor a terminal session. I get an error found to start at the word 'USING'. I've checked/optimized the table. I've searched on the web for faqs and everything, but haven't found any pertinent information. So if it isn't a corrupt table, I'm wondering if the "USING" parameter happened to be deprecated, or something.. Any suggestions would be appreciated 'cause right now I'm stumped. Cameron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
