mysql: delete with join

[Anon]

is there anyway to convert this MS SQL Server
query to mysql, I can't figure out how to do
delete with join in mysql.

DELETE corp_temp
FROM corp_temp x
INNER JOIN corp_main t
ON x.text_no=t.text_no
WHERE t.id<>0

Thanks !

[[deleted]]

From the MySQL manual:

"The multi table delete format is supported starting from MySQL 4.0.0. "

In other words, it will be some time before MySQL can do something like that.
Meanwhile, just use multiple queries.