cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bjcw0 Frequent Visitor
Frequent Visitor

Re: Query with CTE gives error

Did you use Import or Direct Query?

 

Thanks

 

B

Highlighted
roselilly23 Regular Visitor
Regular Visitor

owerRe: Query with CTE gives error

I was getting the issue when using Direct Query with custom sql containing CTEs. I just re-wrote the query to have sub queries rather than the CTEs and it works fine now.