Multiple Delete Query.......

Would the following query (or a variation of it) work in SQL 2000 and/or Access 2002

Delete From tblUser, tblMsg, TblReply where ID = Some number

if there is a way to delete from multiple tables that have the same column name/values with pure SQL, please help me out.....

thank you in advance

No, that won't work. There's quite a few methods you could use to do a delete like that tho..

Create a stored procedure, which runs the 3 delete statements.
Create a trigger
Create a script

alright, thank you........thought I could've saved myself the coding time.....