树型结构数据在关系数据库中用链式存储相关查询实现

树型结构数据在关系数据库中用链式存储相关查询实现

select b.dptcode from base_dept b where b.dptcode_p = (SELECT a.dptcode
FROM base_dept a where a.dptname ='第二餐厅')
union
SELECT a.dptcode
FROM base_dept a where a.dptname ='第二餐厅' /*第二餐厅'的单位代码及其子单位的单位代码*/

select sum(r.opfare) sum_fare from rec_cust_acc r where (r.termid in (SELECT l.termid
FROM base_term l where l.dptcode in (select b.dptcode from base_dept b where b.dptcode_p = (SELECT a.dptcode
FROM base_dept a where a.dptname ='第二餐厅')
union
SELECT c.dptcode
FROM base_dept c where c.dptname ='第二餐厅' ) )) and (r.opdt between to_date('2005-09-01 00:00:00','yyyy-mm-dd hh24:mi:ss')
and to_date('2006-01-10 00:00:00','yyyy-mm-dd hh24:mi:ss')) /*利用第一段代码，通过明细表进行营业额的统计查询代码*/