SQL Union all Statement with Thingworx SQL

[Sathishkumar_C]

I am trying to execute following SQL query statement in MSSQL with Thingworx.

SELECT [C1] FROM [Table 1]
UNION ALL
SELECT [C1] FROM [Table 2];

Getting following issue,

Execute Query failed: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'allselect'.

But its working without "ALL"

[VladimirN · Accepted solution]

 Hi,

There is an article - "Line breaks in SQL Service (Database Thing) are not properly handled in ThingWorx 9.1.0": https://www.ptc.com/en/support/article/CS334683 

[Sathishkumar_C]

Thanks for your support.

Its working as following,

SELECT [C1] FROM [Table 1]
UNION ALL SELECT [C1] FROM [Table 2];