Delete Query

[sjs4u]

Hi, I am having 2 table. I want to delete records having same ID within 1 query. e.g. ID name table1 1 a table2 1 b How can I do? Thanks

[subai]

if you want to remove only from one table you can use this

DELETE FROM TABLE_1 WHERE ID IN (SELECT ID FROM TABLE_2)

or

DELETE FROM Table_1
FROM Table_2 AS t2 INNER JOIN
Table_1 as t1 ON t1.ID = t2.ID

but i don't know if it's possible to remove records from 2 different tables by one single query

I Wish the Life Had CTRL-Z Wizard's First Rule : People are fool,they believe what they want to believe or what they afraid to believe www.subaitech.blogspot.com

[Declan Bright]

It you have a relationship setup between the 2 tables on the id column with the cascading delete property set, then deleting the records for one table will delete the corresponding records from the other table

Declan Bright www.declanbright.com

[TheFM234]

Write a stored procedure:

Create Proc usp_DeleteFromTables
@Id int
As

Delete From Table1
Where Id = @Id

Delete From Table2
Where Id = @Id

Then execute it. For example, if you wanted to delete id # 2:

Exec usp_DeleteFromTables 2