Re: Creating a view over identically structured tables

Posted in 1996

Michael Aubury — 30 Jan 1996 05:43:04 -0500 — source: Informix-list mailing list archive (1991-1998)

The only way to be able to do this type of processing is using the union statement. select * from tab1 union all select * from tab2.... unfortunatly this isnt available when using views ! If anyone can explain to me why not - id appreciate it.. Mike Aubury