• Thom A - Tuesday, February 28, 2017 9:23 AM

    You don't "delete" from views. Views are simply a predefined SELECT statement. If you need something deleted that is displayed in a view, you have to delete it from the base table. If your view collects data from several tables, that may mean deleting data in all or some of those tables.

    As John said, I don't think the aim should be to "delete" the data in the table. it should be to filter that data in the view. That might be as easy as adding the following to your WHERE statement on your view:
    AND status != 'C'

    Or, if you are bothered about ANSI compliance

    AND status <> 'C'

    😉

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.