更新撤回:
select QLBH,GYTDMJ from QL_TDXG as of timestamp to_timestamp('2022-10-31 16:48:00', 'yyyy-mm-dd hh24:mi:ss');
查询:
SELECT A.QLBH,SUM(C.FTTDMJ) FROM QL_TDXG A, DJ_TSGL B, FC_H_QSDC C WHERE A.GYTDMJ IS NULL AND A.FTTDMJ IS NULL AND A.DYTDMJ IS NULL AND A.SLBH = B.SLBH AND B.BDCDYH = C.BDCDYH AND C.FTTDMJ IS NOT NULL GROUP BY A.QLBH