mysql: delete with join

[admin]

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 !