My understanding with SQL 6.5 was that a UNION query was not permitted in a
I recently installed MSDE/SQL7 to use with Access 2000.
As an experiment, I tried to create a view that included a UNION clause. It
gave me an error saying that "UNION is not supported" but then it created
the view anyway, and it appears to work fine.
Has anyone had any experience with this in MSDE or in the full size SQL7? I
need this view to do some crucial things, but I want to know that its not
going to blow up later in some way...