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

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

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')) /*利用第一段代码，通过明细表进行营业额的统计查询代码*/