I wrote a query in Microsoft SQl Server Management Studio and is returning all the data without issue. However, this same query in the sync service connector throws an error about it being an invalid query.

The query is following the example below.