我希望这不会比您的第一个查询慢:
SELECT t1.* FROM t_deposit_trx t1 INNER JOIN t_settle_trx t2 ON t1.remit_tx_id=t2.tx_id WHERE t2.report_date >= '2019-03-01' AND t2.report_date <= '2019-03-02' AND t2.tx_type='CANCEL';
