SQL standard is that if you have an outer query that's referencing a single table, which is a requirement in the SQL standard, then a deletion from the view is going to result in a deletion from that one table. 