Avatar of Jacque Scott
Jacque Scott
Flag for United States of America

asked on 

DELETE rows from a specific table

I need to delete some rows from a table.  I need confirmation of this delete statement.

delete *
from MattersQNVTRST q
where matters in (select matters from matters m where m.Matters = q.Matters and m.AreaOfLaw = 'catrst')

Open in new window


I want to make sure that only the rows in table MattersQnvtrst will be deleted and not the rows in table Matters.
Microsoft SQL Server 2008SQL

Avatar of undefined
Last Comment
SThaya

8/22/2022 - Mon