T122 WITH (excluding RECURSIVE) in subquery

[TedCraft]

You have an error in your SQL syntax: SELECT C.CUST_NAME C.CUST_CITY FROM CUSTOMER c WHERE c.agent_code in (WITH T121 AS (SELECT AGENT_CODE FROM AGENTS) SELECT C.CUST_NAME FROM CUSTOMER c LEFT JOIN T121 T ON T.AGENT_CODE = C.AGENT_CODE) no viable alternative at input 'in' at line 1 position 68 near @1568:69='in'<106>1:68

[TedCraft]

SELECT C.CUST_NAME, C.CUST_CITY FROM CUSTOMER c WHERE c.agent_code in (WITH T121 AS (SELECT AGENT_CODE FROM AGENTS) SELECT C.CUST_NAME FROM CUSTOMER c LEFT JOIN T121 T ON T.AGENT_CODE = C.AGENT_CODE)

[makssent]

• "Table or view T121 does not exist."