Re: Creating Views on Multiple Identical Tables

Posted in 1997

Joe Lumbley — Wed, 14 May 1997 19:05:13 GMT — source: Informix-list mailing list archive (1991-1998)

Colin McGrath (cmm@trac3000.ueci.com) wrote: : > >|Is there a way to create a view on a group of tables that have : > >|identical col. names? The tables contain data from the 4 quarters of : > >|the year : Doesn't work yet with INFORMIX-OnLine Dynamic Server Version 7.22.FC2 on : a DEC alpha, you still get a syntax error on the line with the word "UNION". Informix Guide to SQL (Syntax version 7.2, vol 1) page 1-225. UNION is not supported in a view. Joe : -- : _____________________________________________________________________ : | Colin McGrath cmm@trac3000.ueci.com | : | Raytheon Engineers & Constructors, Inc. (215) 422-4144 | : | Phila, PA, USA Standard Disclaimers Apply | : |___________________________________________________________________| -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) ---------------------------------------------------------------------------