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