sqlite – 使用SQL’with’子句时出错

WITH RECURSIVE under_cust (affiliation_id,from_customer_id,to_customer_id,to_name,parent_customer_type,child_customer_type,level) 
 AS (SELECT af.affiliation_id,0 LEVEL 
     FROM   affiliation af,customer c 
         WHERE  to_customer_id <> from_customer_id 
                AND af.from_customer_id = c.customer_id 
                AND af.to_customer_id = 1000022559337 
         UNION ALL 
         SELECT af.affiliation_id,af.from_customer_id,af.to_customer_id,af.to_name,af.parent_customer_type,af.child_customer_type,under_cust.level + 1 LEVEL 
         FROM   customer c,affiliation af 
                JOIN under_cust smr 
                  ON smr.from_customer_id = af.to_customer_id 
         WHERE  af.from_customer_id = c.customer_id 
) SELECT affiliation_id,to_customer_id   parent,from_customer_id child,level 
FROM   under_cust

如果在旧版本上运行查询,则会出现语法错误.

要么升级你的sqlite,要么在没有WITH语法的情况下使你的代码工作.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!