1       17:06:36  SQL Execute: ORACLE - select  distinct  C.ZWXM00,C.YGBH00,
 (select count(*) from  ic_ywls00 where FSJE00 =  0 and YWCZ00 = '1' and YGBH00 = C.YGBH00  and  CZRQ00 >= '20200102' and  CZRQ00 <= '20200102' and  CZRQ00||CZSJ00 >= '2020010200:00:00' and  CZRQ00||CZSJ00 <= '2020010223:59:59') MFZS00, 
 (select count(*) from  ic_ywls00 where FSJE00 <> 0 and YWCZ00 = '1' and YGBH00 = C.YGBH00  and  CZRQ00 >= '20200102' and  CZRQ00 <= '20200102' and  CZRQ00||CZSJ00 >= '2020010200:00:00' and  CZRQ00||CZSJ00 <= '2020010223:59:59') SFZS00, 
 (select count(D.YWID00) from  ic_ywls00 D,IC_YHXX00 E,BM_BRXXB0 F where D.ICKH00=E.ICKH00 AND E.BRID00=F.BRID00 AND  (D.CZRQ00||D.CZSJ00)<>(F.CZRQ00||F.CZSJ00) AND YWCZ00 = '1' and D.YGBH00 = C.YGBH00  and  D.CZRQ00 >= '20200102' and  D.CZRQ00 <= '20200102' and  D.CZRQ00||D.CZSJ00 >= '2020010200:00:00' and  D.CZRQ00||D.CZSJ00 <= '2020010223:59:59') BGKS00, 
 (select count(*) from  ic_ywls00 where 1 = 1       and YWCZ00 = '1' and YGBH00 = C.YGBH00  and  CZRQ00 >= '20200102' and  CZRQ00 <= '20200102' and  CZRQ00||CZSJ00 >= '2020010200:00:00' and  CZRQ00||CZSJ00 <= '2020010223:59:59') HJZS00  
  from  IC_YWLS00 B,BM_YGBM00 C 
 where  B.YWCZ00 = '1' and  B.YGBH00 = C.YGBH00 
 and  CZRQ00 >= '20200102' and  CZRQ00 <= '20200102' and  CZRQ00||CZSJ00 >= '2020010200:00:00' and  CZRQ00||CZSJ00 <= '2020010223:59:59'
 and B.ICKH00 not like 'TJ%' 

2       17:06:36  SQL Error: ORACLE - ORA-00918: column ambiguously defined

3       17:06:36  SQL Error: ORACLE - Unmapped SQL Error Code: 918
4       17:06:36  SQL Data In: ORACLE - Rows affected = 0