Page 1 of 1

CTE in Query Builder

Posted: Thu 11 Dec 2014 20:42
by KCarterSr
When I try to use a simple query in the query builder that has a CTE I get the following error.

Example:

WITH statement......
SELECT statement.....

Error: One of the following statements expected: SELECT, INSERT, UPDATE, DELETE.

The code is correct. Is this a bug?

Thanks
K. Carter Sr.

Re: CTE in Query Builder

Posted: Fri 12 Dec 2014 08:45
by .jp
Unfortunately, Query Builder does not support CTE yet. You would suggest the feature at our User-Voice forum.