Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
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'.
…