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

8/22/2022 - Mon