Re: deleting from multiple tables syntax error

2004-11-10 Thread cmetcalf
Turns out to be 4.1.7 This suggestion fixed my query, thanks. I'd tried that approach yesterday, but it was on an older version of MySQL (on our non-production server; I wasn't paying attention to the versions of MySQL betw. our test and production servers) - so my previous attempts with this syn

deleting from multiple tables syntax error

2004-11-10 Thread cmetcalf
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_