Delete two rows

[souravsasi]

Hi,
i have two tables..both the tables having common field called "ID"

i want to delete rows from both the table simultaneously.

i used like this

DELETE FROM tbl1 u,tbl2 a WHERE ID=1 AND u.ID=a.ID

can give suggestion?

[PHPThorsten]

Which database are you using?

If it's mysql you'll need the 4.0.x version to do this. http://www.mysql.com/doc/en/DELETE.html

but why not just delete one after the other?

[Pig]

Just run 2 queries and save yourself a headache.