Re: create view as table unions - Syntax Errors?

Posted in 1999

Mark D. Stock — Tue, 11 May 1999 12:05:15 +0200 — source: Informix-list mailing list archive (1991-1998)

Adrian Cho wrote: > > Thanks for the replies. So, Informix 7.2x does not support views with > unions in SELECT statement clause. > > Does anyone have ideas how to achieve something equivalent. Merging the > tables together to a physical table is the last thing I want to do but I > wish to learn the alternatives. > > Thanks in advance!! Upgrade to version 7.30 or 7.31? Just a thought. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+