Re: Creating Views on Multiple Identical Tables

Posted in 1997

Rudy Fernandes — Wed, 14 May 97 04:14:57 GMT — source: Informix-list mailing list archive (1991-1998)

In article <EA3A5F.G1x@nonexistent.com>, Jacob Salomon <jake@apparel.net> wrote: >dhinkle@firstam.com (David J. Hinkle) 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, ie: <snip> >I have heard rumors that the a view on a union is legal in the SQL-92 >standard and that the Informix engines of release 7.2+ conform to SQL-92 >syntax. However, I have no first hand knowledge of this and don't mind >trolling for an answer. Unfortunately, v7.20 does NOT allow UNION views. ----------------------- Rudy Fernandes GIC, Kuwait OL 7.20UC4, 4GL 6.04UC1 -----------------------