> Here's the syntax I'm using, and the error message I get:
>
> DELETE FROM
> vsnetwork LEFT JOIN master
> ON master.email=vsnetwork.email
> WHERE master.email Is Null;
>
> ERROR 1064: You have an error in your SQL
> syntax near 'LEFT JOIN master ON master.email=vsnetwork.email
> WHERE master.email Is Null;' at line 2
>
> If I change the DELETE command to SELECT COUNT(*), or SELECT *,
> it works great.
While it is a big pain, you cannot use multiple tables in a delete statement
in MySQL. You have to select, then step through each record and issue a
delete. I don't know if there are any plans to add this in the future.
