父级得到子级数据SQL怎么写

楼主，请提供表结构域数据，我给你构建这么多数据无意义。
如果按照你标题要求，就是start with fuid=0 connect by prior id=fuid。然后你统计就是了。如果要我做，请提供表结构，与测试数据
表1：
create table YUEBPZB
(
  id       NUMBER(15) not null,
  xuh      NUMBER(15) not null,
  itemname VARCHAR2(200) not null,
  fuid     NUMBER(15) not null,
  jib      NUMBER(1) not null
);
insert into yuebpzb (ID, XUH, ITEMNAME, FUID, JIB)
values (100826472, 1, '一、全国订货', 0, 1);
insert into yuebpzb (ID, XUH, ITEMNAME, FUID, JIB)
values (100826473, 1, '（一）统配矿合计', 100826472, 2);
insert into yuebpzb (ID, XUH, ITEMNAME, FUID, JIB)
values (100826474, 1, '1、河北小计', 100826473, 3);
insert into yuebpzb (ID, XUH, ITEMNAME, FUID, JIB)
values (100826475, 1, '（1）峰峰集团', 100826474, 4);
insert into yuebpzb (ID, XUH, ITEMNAME, FUID, JIB)
values (100826476, 1, 'Ⅰ.原煤合计', 100826475, 5);
insert into yuebpzb (ID, XUH, ITEMNAME, FUID, JIB)
values (100826477, 1, '1.薛村矿', 100826476, 6);
insert into yuebpzb (ID, XUH, ITEMNAME, FUID, JIB)
values (100826478, 2, '3.小屯矿', 100826476, 6);
表2：
create table YUEBMKGL
(
  id         NUMBER(15) not null,
  meikxxb_id NUMBER(15) not null,
  yuebpzb_id NUMBER(15) not null
);
insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826484, 232196080, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826485, 232196081, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826486, 232196082, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826487, 232196083, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826488, 232196532, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826489, 232196612, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826490, 232196957, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826491, 232464599, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826492, 232464684, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826493, 232464689, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826494, 232464692, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826495, 232493398, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826496, 232503302, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826497, 232512716, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826498, 232562319, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826499, 232570521, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826500, 232581230, 100826477);insert into yuebmkgl (ID, MEIKXXB_ID, YUEBPZB_ID)
values (100826501, 232570913, 100826477);
表3：
create table DIAOR16FKBB
(
  id          NUMBER(10) not null,
  riq         DATE not null,
  fenx        VARCHAR2(20) not null,
  meikxxb_id  NUMBER(10) not null,
  kuangfgyl   NUMBER(15,2)
);
insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826424, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232196612, 3644.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826407, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232196612, 3644.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826423, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232196957, 32311.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826406, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232196957, 32311.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826435, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232493398, 34242.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826418, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232493398, 34242.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826422, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232570521, 71.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826405, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232570521, 71.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826430, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232570913, 3563.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826413, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232570913, 3563.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826426, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232581230, 2636.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826409, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232581230, 2636.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826427, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232618687, 43521.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826410, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232618687, 43521.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826395, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232666823, 24246.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826402, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232666823, 24246.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826431, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232672899, 3573.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826414, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232672899, 3573.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826425, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232685166, 13591.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826408, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232685166, 13591.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826392, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232685170, 3465.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826399, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232685170, 3465.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826436, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232685177, 2622.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826419, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232685177, 2622.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826396, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232685180, 2962.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826403, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232685180, 2962.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826393, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232734369, 84236.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826400, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232734369, 84236.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826434, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232739741, 585.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826417, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232739741, 585.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826437, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232743062, 1211.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826420, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232743062, 1211.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826390, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232745431, 3031.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826397, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232745431, 3031.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826429, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232747820, 8481.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826412, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232747820, 8481.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826433, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232751120, 1049.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826432, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 232751120, 81.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826416, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232751120, 1049.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826415, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 232751120, 81.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826394, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 601195979, 37500.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826401, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 601195979, 37500.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826421, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 601195980, 13250.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826404, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 601195980, 13250.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826391, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 601195986, 5237.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826398, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 601195986, 5237.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826428, to_date('01-01-2013', 'dd-mm-yyyy'), '本月', 601195987, 4177.00);insert into diaor16fkbb (ID, RIQ, FENX, MEIKXXB_ID, KUANGFGYL)
values (2323826411, to_date('01-01-2013', 'dd-mm-yyyy'), '累计', 601195987, 4177.00);
你提供的数据与你期望得到的结果感觉不符。表YUEBMKGL中的数据都是表1中（1.薛村矿）的数据。。因为yuebpzb_id都等于100826477。所以你的期望结果中的 3.小屯矿  数据是怎么来的？

调试易

父级得到子级数据SQL怎么写

解决方案 »