>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.

Yes, if the Subscriber is not updatable in the view. i.e., The key field for Subscriber has not been identified in the view.