Re: using UNION in view statment

Posted in 2000

Isidre PONS ROCA — Mon, 26 Jun 2000 09:08:23 +0200 — source: Informix-list mailing list archive (1991-1998)

En musman@my-deja.com va escriure el dia 24 Jun 2000, a les 15:48: > 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. I belive that UNION is not suporten on views before 7.31 version. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------