different databases have different strategies. I do not understand why after union or join you can not update view. As long as data integraty is maintained, views should be able to be modify. The main purpose for a view is to minimize denormolization and maintain security. It could endup behaving differently in different databases though.