Sage X3

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