Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    130

    Unanswered: Using UNION in Views

    I'm trying to create a view in SQL Server 2000 using UNION and when I try to show the view I get the error:

    'The Query Designer does not support the UNION SQL construct.'

    but the view runs and displays the results.

    Why is that?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    That just means it can't show the table schema in the diagram pane.

    blindman

  3. #3
    Join Date
    Mar 2003
    Posts
    130
    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •