Re: Syntax error trying to formulate a sub-query

Posted in 1999

Mark D. Stock — Thu, 18 Mar 1999 16:03:10 +0200 — source: Informix-list mailing list archive (1991-1998)

"Art S. Kagel" wrote: > > OK, it has been a while, but now I have a question for the community. > > IDS 7.21UD3 and IDS 7.24UC7 > > Now on 7.30UC3 I CAN create the view and use it in the subquery but > I still cannot use the UNION in the subquery itself. Very odd! Any > ideas team? And just to top off all the valid responses, the use of UNION in views was one of the new features introduced in version 7.30. 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"!|/ ////////| +----------------------+-----------------------------------+-----------+