-
Problems with SP5a and view using UNION and JOIN
Hi there!
I have a view:
CREATE VIEW Uniao AS
SELECT * FROM Tabela1
UNION ALL
SELECT * FROM Tabela2
With SP3, it's work very well:
SELECT * FROM Uniao
LEFT OUTER JOIN Tabela3 ON
Uniao.CampoX = Tabela3.CampoX
With SP5a, don't works and this error is returned:
Msg 4409, Level 20, State 1
The columns in the query definition and the view definition
do not match.
Thanks for help me
Carlos Santos
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|