Delete data from multible tables

Question

I have two tables say table X and table Y. I want to delete all data from table X with column value = x1 and also want to delete data from table Y with column value = x1.

How can i achieve this using a single Delete statement?

Thanks

Answer 1

Since you want to delete from multiple tables, you should specify the table you want to delete so you will not get syntax error.

DELETE x, y
FROM   x INNER JOIN y ON x.Col = y.Col
WHERE  x.Col = 'x1'

http://www.sqlfiddle.com/#!2/00ab7/1

Answer 2

delete x,y from x,y where x.colname='x1' and y.colname='x1'

Try this query.

Hope its helpful.