Is there a bug or limitation on having multiple CTE's in a native query? I'm just doing two separate CTE statements, but it is not recognizing the second CTE statement, instead telling me that "Error: syntax error at or near WITH position".
This is basically the format I have
with cte_1 as (select * from x),
with cte_2 as (select * from y)
select * from x_test a
join y_test b on a.keytojoin= b.keytojoin
(This is something that can't be done with a subquery unfortunately, in this case)
EDIT: I should add that queries with one CTE work fine, it's an issue only with multiple CTE's