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.