Delete rows in one table based on another table

• rbarrera

  Mr or Mrs. 500

  Points: 575

  More actions

  June 17, 2008 at 2:16 pm

  #192703

  I need a SQL statement that will delete the rows in one table if that value exists in another table.

  The first table has a list of file paths that I want to delete if those file paths exist in table 2.

  Help is much appreciated.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  June 17, 2008 at 2:17 pm

  #830047

  You can do that a couple of ways.

  delete from dbo.Table1

  where Path in

  (select Path

  from dbo.Table2)

  delete from dbo.Table1

  from dbo.Table1

  inner join dbo.Table2

  on Table1.Path = Table2.Path

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• rbarrera

  Mr or Mrs. 500

  Points: 575

  More actions

  June 18, 2008 at 9:22 am

  #830559

  Thanks a bunch.