Is there a MySQL command to do what I thought this command would do:
DELETE FROM tableA WHERE tableA.id = tableB.id
In other words, delete from one table based on fields matching those in another table. That command doesn't seem to work, and there's no discussion of such things in the DELETE section of the MySQL manual.
Any help would be appreciated.
DELETE FROM tableA WHERE tableA.id = tableB.id
In other words, delete from one table based on fields matching those in another table. That command doesn't seem to work, and there's no discussion of such things in the DELETE section of the MySQL manual.
Any help would be appreciated.