select * from table2 t1
where t1.id
in (
select id from table1 start with id = xx connect by prior id = parntid
)table1为树结构表 table2为一般表
这样的查询在eclipse中执行为什么会报“缺失右括号”的错误?
难道 start with id = xx connect by prior id = parntid 有什么特殊的含义?
where t1.id
in (
select id from table1 start with id = xx connect by prior id = parntid
)table1为树结构表 table2为一般表
这样的查询在eclipse中执行为什么会报“缺失右括号”的错误?
难道 start with id = xx connect by prior id = parntid 有什么特殊的含义?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货