Re: [Q] 1. shared object 4GE 2. CREATE VIEW + UNION

Lin FuXiong wrote: > Question 2. Create a view with "UNION" ? > ----------- > Is it possible to create a view with the function like union? > How can I do it ? > P.S. Please don't JOIN many tables in a single select ... > > Hope you can help me. Thanks in advance. > > --- > Lin FuXiong > E-mail: gis81566@cis.nctu.edu.tw Tried it, cant do it. At the time I wanted to pull data into a spreadsheet through an ODBC from informix, then i read the manual where it said "cant do this" so i told the boss "maybe i can create temp tables and ..." he said never mind. -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** anyone elses **** *** Disclaimer: These are the opinions of the poster not Amgen Inc.***