SQL：select * from PT_ORG_INFO START WITH id='102' CONNECT BY PRIOR id=par_idView Code连表递归查询SQL：select info.* from PT_CAMERA_INFO infojoin (select * from PT_ORG_INFO START WITH id='102' CONNECT BY PRIOR id=par_id) org on org.id=info.org_idwhere 1=…
SQL：
select * from PT_ORG_INFO START WITH id='102' CONNECT BY PRIOR id=par_id
连表递归查询SQL：
select info.* from PT_CAMERA_INFO info join (select * from PT_ORG_INFO START WITH id='102' CONNECT BY PRIOR id=par_id) org on org.id=info.org_id where 1=1
扫一扫在手机打开
评论
已有0条评论
0/150
提交
热门评论
相关推荐
