Management Studio & Views containing unions

Hi

I'm having a major beef with Management Studio Express when it comes to
editing Views that contain a UNION statement. For starters, it can't display
the View, which I guess is OK, the old tool couldn't do that either. But,
the syntax verification doesn't work either.. I get an "Incorrect Syntax
near UNION" error each time. But, if the syntax is valid, saving is no
problem.. and neither is a select on the view.

Why does MSE choke on a union even if the query is valid? I can understand
the issues regarding displaying a query that contains unions, but if valid
syntax is used, why can a query not be syntax checked?

Regards
Stephan


.

Relevant Pages

  • Re: Access Query
    ... UNION query to put the ... Because of the syntax, ... >The left and right square brackets are required, ...
    (microsoft.public.access.formscoding)
  • Re: displaying multiple dates in a table
    ... If you cannot do that then you would need to build a fairly complex query ... that as the source of your birthday query. ... Sample Union query - ... display per month... ...
    (microsoft.public.access.queries)
  • RE: Adding to a combo box list that is based on a table
    ... the list of fields returned by the query. ... how would I include the UNION statement? ... several fields to display, but the bound column is column 2, the record ID. ...
    (microsoft.public.access.formscoding)
  • Re: Union query retrieves 1000 records only
    ... >I made a union query that I then display as a cross tab. ... By running the query only, ...
    (microsoft.public.access.queries)
  • Re: Union Query not working yet
    ... I *think* we have to explicitly mentioned the fields, when we use a UNION. ... I can't seem to get this union query thing going right. ... Instead of selecting the most ... Maybe with the exact syntax life would be easier. ...
    (microsoft.public.access.queries)