RE: using UNION in view statment

Posted in 2000

Bernstein, Rick — Sat, 24 Jun 2000 09:55:43 -0700 — source: Informix-list mailing list archive (1991-1998)

IDS 7.24 does not support UNION in views, but IDS 7.3x does. -----Original Message----- From: musman@my-deja.com To: informix-list@iiug.org Sent: 6/24/00 8:48 AM Subject: using UNION in view statment Hi We are using Informix 7.24 on Solaris 2.6. Can we use UNION while creating view. I'm getting an error while executing the below sql. (The SQL is only for testing the VIEW statment.) create view tview3 (item_num,manu_code) as select item_num,manu_code from items where item_num=1 union select item_num,manu_code from items where order_num=104 Can any help me on above. Thanks Muhammad Usman musman@iffco.com Sent via Deja.com http://www.deja.com/ Before you buy.