I have a view that uses a UNION clause. As the UNION is not supported by
the view builder, I cannot produce such using it.

If I create the view with code, I am required to have exclusive access to the database.

Does anyone know of a way to incorporate views that use clauses outside the scope of the view builder in a shared database?

I would like this view to be a permanent part of
the database.

Any help is appreciated,

Chris