Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!zaphod.mps.ohio-state.edu!sdd.hp.com!ucsd!pacbell.com!pacbell!rtech!squid!robf
From: robf@squid.rtech.com (Robert Fair)
Newsgroups: comp.databases
Subject: UNIONS/VIEWS
Keywords: ingres
Message-ID: <5670@rtech.Ingres.COM>
Date: 2 Aug 90 18:44:26 GMT
Sender: news@rtech.Ingres.COM
Reply-To: robf@squid.Ingres.COM (Robert Fair)
Distribution: na
Organization: Ingres Corporation, Alameda CA 94501
Lines: 15

Ingres 6.x SQL *does* handle view definitions containing UNION and UNION ALL,
e.g.
	CREATE VIEW a_and_b
	AS
		SELECT x FROM a
	UNION 
		SELECT x FROM b

works just fine.

Robert Fair
Premium Support Group
Ingres Corporation, NJ

Standard disclaimer applies.