<div>
the message returned by Sybase :<br />
197- SET operators may not appear in the definition of a view<br />

</div>


the message returned by Sybase :
197- SET operators may not appear in the definition of a view


<div>
Adjusted points to 200<br />

</div>


<div>
<div class="content wysiwyg-content">
In Sybase 11 I can't use UNION selects (6) in a VIEW. <br />
Anybody an idea to work around that ?
</div>
</div>


In Sybase 11 I can't use UNION selects (6) in a VIEW. 
Anybody an idea to work around that ?

can't use a UNION in a VIEW - workaround ?

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.