Multi Table Delete in 3.23.47

[zzapper]

Hi,

The following query runs fine in recent versions of mysql 4.1x etc

delete from t2 using tbl_User as t1,tbl_UserTopic as t2 where
(t1.txtemail='fredred@stripped')
and (t1.intID = t2.intID);

But not in 3.23.47 I can't find any reference in the manuals to why this might be.

Is there any change in syntax which will make the query work in 3.23.47?


-- 
zzapper
vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?"
http://www.rayninfo.co.uk/tips/ vim, zsh & success tips