c# - Looking for Delete statement for this Select statement -

i have db in production , have been brought in make changes. going except can't delete execute. know it's because of joins , incorrect ref. integrity etc. can't change that. select statement below executes without issue , displays in gridview:

select    [stock inventory].materialnumber,    [stock inventory].[optimum stock] optimum_stock,    customerservice.part,    customerservice.samplesrequired,    customerservice.frequency,    customerservice.country     [stock inventory]    inner join customerservice      on [stock inventory].materialnumber = customerservice.part 

i looking use delete link part of generated table if have not provided enough information, please let me know

since mentioned needing delete both tables this:

begin transaction  declare @deleted table (materialnumber int) --whatever data type need delete s output deleted.materialnumber @deleted   [stock inventory] s   inner join customerservice c     on s.materialnumber = c.part   delete c customerservice c join @deleted d     on d.materialnumber = c.part      commit transaction