T122 WITH (excluding RECURSIVE) in subquery

Question

T122 WITH (excluding RECURSIVE) in subquery

TedCraft opened this issue 7 months ago · 2 comments

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

Answer 1 · 2024-06-17T09:58:20.000Z

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)

Answer 2 · 2024-07-04T13:18:39.000Z

"Table or view T121 does not exist."