Very Computer

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...

Thanks!

Derek

Views containing UNIONs were not supported **until** SQL Server 6.5. Beginning
with SS6.5, SQL Server has supported views containing UNIONs. SS7.0 continues
this support.

Perhaps you could post the DDL of your table schemas and the view so that we can
understand what caused the error message to appear.

Quote:> My understanding with SQL 6.5 was that a UNION query was not permitted in a
> view.

> 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...

> Thanks!

> Derek