SQL Server 7: Using Unions in Views
Author: Daniel Trembath, date unknown
Keywords: Microsoft SQL Server 7 MSsSQL Views Unions Work

I've been having trouble all morning trying to create a view in SQL Server 7 that has a UNION statment in it. The enterprise manager designer will not let you do this, nor will a lot of RDBMs.

However, very simply, you can do it in the direct editor. So yes you can use UNIONS in VIEWS!

In the Enterprise manager if you right click on the view and click design, you will not be allowed to put in a UNION. But if you just double click on the view and get the direct editor, you can paste in your sql with a union operator and it will work. Be carefull not to write over the CREATE line at the very top.

Thanks to LucasG for that one