help with a query?

[harlowhair]

Hi
I might just be really dumb, but.. Is it possible to delete from several tables, each with a common field at the same time? e.g

DELETE FROM table1, table2, table3 WHERE commonfield=10;

I can't figure out how to do this - should i be using a join?

Thanks in Advance
Rob

[[deleted]]

http://www.mysql.com/doc/en/DELETE.html

Note that multi table deletes are not supported until version 4.0....