MySQL DELETE query with INNER JOIN gives error

Asked Dec 09 '15 at 21:43

Active Dec 09 '15 at 22:38

Viewed 44 times

This SELECT statement works:

SELECT *
FROM mailing
INNER JOIN NoMail ON mailing.EmailAddress = NoMail.EmailAddress

But this DELETE doesn't:

DELETE *
FROM mailing
INNER JOIN NoMail ON mailing.EmailAddress = NoMail.EmailAddress

I get this error:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM mailing INNER JOIN NoMail ON mailing.EmailAddress = NoMail.EmailA' at line 1

edited Dec 09 '15 at 22:38

whereisSQL

asked Dec 09 '15 at 21:43

Timothy

Take out the `*`? If that does not work, replace it with the table_names (comma separated) instead. – Uueerdo Dec 09 '15 at 22:08
What I did is replace the asterisk with the actual table name: – Timothy Dec 09 '15 at 22:12

MySQL DELETE query with INNER JOIN gives error

0 Answers0