I have a view which is based on two tables - subscriber and money table. The link is on a field call c_id which is in both tables. I need to delete only the record in the money table but not the record in the subscriber table. Is there any way I can do this using this view.