start with 问题

[ibmlihw]

SELECT 显示最上面的父级,nsfxm_id
FROM chargesys.c_charge_item a
START WITH nsfxm_id IN (SELECT ncalccolumn
FROM z_report_define_detail
WHERE nreportid = 7)
CONNECT BY nparentid = PRIOR nsfxm_id

我怎样将第一个字段总显示为显示最上面的父级

[liuyi8903]

表结构和数据放点上来.

[ibmlihw]

c_charge_item
NSFXM_ID VSFXM_MC NPARENTID
1 s
2 a 1
3 a 2
4 j
5 r 4
6 l 5


z_report_define_detail
NCOLUMNCODE VCOLUMNNAME NCALCCOLUMN NREPORTID
1 q 1 7
1 q 4 7