sybperl-l Archive

From: Simon Haven <Simon dot Haven at wdr dot com>
Subject: Re: how can i create view using union operator
Date: Jul 21 1999 8:55AM

You can't use the UNION operator in a view definition. It's a SQL server restriction.
Although you could create separate views for the SELECT statements you are using in the UNION, and then use a UNION to select from those views.

HTH,
Simon Haven

Begin forwarded message:

From: sksharma 
Organization: inflibnet Centre
To: SybPerl Discussion List 
Subject: how can i  create view using union operator
Date: Wed, 21 Jul 1999 09:33:16 +0530
X-Mailer: KMail [version 1.0.14]
Reply-To: SYBPERL-L@listproc.net
Sender: owner-SYBPERL-L@listproc.net
X-Listprocessor-Version: 8.2.07 -- ListProc(tm) by CREN

hi..			
i want to create view through sybperl using UNION operator. during creation it
is giving error . Is This  an error of sybperl or sybase ?. Is there anyothere
way to create a view using UNION operator.
   --
*********************************************************			
	Name   :Surender Kumar Sharma
	Desgn. :Scientist
	Org.   :Information and Library Network Centre
	Loc    : Near Gujrat University guest house,
        	 Navrangpura,Ahmedabad (India)
	Ph.    : 6301972,6305971
	URL    : www.inflibnet.ernet.in
	E-mail :sksharma@inflibnet.ernet.in
********************************************************


This message contains confidential information and is intended only 
for the individual named.  If you are not the named addressee you 
should not disseminate, distribute or copy this e-mail.  Please 
notify the sender immediately by e-mail if you have received this 
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free 
as information could be intercepted, corrupted, lost, destroyed, 
arrive late or incomplete, or contain viruses.  The sender therefore 
does not accept liability for any errors or omissions in the contents 
of this message which arise as a result of e-mail transmission.  If 
verification is required please request a hard-copy version.  This 
message is provided for informational purposes and should not be 
construed as a solicitation or offer to buy or sell any securities or 
related financial instruments.