Using UNION or UNION ALL in SQL Query Tools

Hello all,

Has anyone had a luck with using the UNION or UNION ALL join types when creating a new view within the X3?

When I try to do it I get the message - 

[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '0'.

When I compile the view in SQL Managment studio it works just fine but I need it to work in X3 as well.

Obviously, the Union jin is used for a reason, it grabs the data from 3 different parts of the system and puts them together.

When I deploy individual segments of the big view, it works fine, so there is no problem with data, it looks to me that X3 simply does not like UNION type of join.

Any suggestions? Thanks