摘要： WITH no1 AS( SELECT a.benji AS zong ,b.* FROM dengji a INNER JOIN dengji b ON a.benji=b.shangji AND a.benji IN (SELECT shangji FROM dengji) ), no3 AS( SELECT x.zong,y.benji,y.shangji FROM no1 x INNE... 阅读全文