>Okay she can switch views anytime she wants by deleteing or adding wms_ITRN_all, if she removes wms_ITRN_all than she uses the wms_ITRN view.
>I said she was smart!

Jim.

The alias doesn't have to be the name of the other view. Any alias will do. For example

FROM wms_ITRN_all itrn
--
FROM wms_ITRN itrn
--
FROM wms_ITRN_somethingelse itrn