Submitted by: @tonal

Votes: 1

Simple queru with CTE work
{code:sql}
with
CHARGES (ID) as (select ID from CHARGES CR where PERIOD = '2009')
select ID from CHARGES CR
{code}

But if remove aliase in last {bold}select{bold} recive error
{code:sql}
with
CHARGES (ID) as (select ID from CHARGES CR where PERIOD = '2009')
select ID from CHARGES
{code}

{quote}
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
CTE 'CHARGES' has cyclic dependencies.
{quote}

====== Test Details ======

See test for CORE5667