RE: create view as table unions - Syntax Errors?
My 7.24 manuals state that UNION may not be part of a view definition.
> -----Original Message-----
> From: Adrian Cho [mailto:adrian_cho@lineone.net]
> Sent: Monday, May 10, 1999 1:57 PM
> To: informix-list@iiug.org
> Subject: create view as table unions - Syntax Errors?
>
>
> I have got a number of tables,
>
> item_d0, item_d1, item_d2, ...
>
> They are of the same schema definition.
>
> Instead of merging them into one giant table, I tried to
>
> CREATE VIEW item_all AS
> SELECT * FROM item_d0
> UNION
> SELECT * FROM item_d1>
> dbaccess complains a syntax error just before the keyword UNION.
>
> I tried some variations like
>
> CREATE VIEW item_all (item_id) as
> SELECT item_id FROM item_d0
> UNION
> SELECT item_id FROM item_d1>
> but I still don't go any where.
>
> I would appreciate if anyone can point me to any blind spots.
>
> Thanks in advance.
>
> "Adrian"
>
>