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 syntax didn't work, because the environment didn't support it; chalk it up to 'human error' this time 'round. I appreciate the quick reply. Cameron > Did you upgrade to 4.0.17 or 4.1.7? In 4.1, you have to use the alias > between FROM and USING: > > DELETE FROM rls USING rsrc_linx_specialty rls,... > > This is documented at the bottom of the manual page you referenced. > > Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
