I have a union query in SQL 2000 that I would like to turn into a view. I
can run the union query in the SQL Server query builder by entering the SQL
directly. However, when I try to save the query as a view, it complains
that there are no fields in the result set.
Thanks,
Bruce