有没有办法修改这个查询,让它检查frp_fundraisingprogram.start_date是否不为空或包含缺省值?SELECT frp_fundraisingprogram.id AS id WHERE frp_fundraisingprogram.start_date<= DATE_ADD(UTC_TIMESTAMP(), INTERVAL - 2 day)
AND frp_fundraisingprogram.date_
select
,case when charge.charge_id =case when charge.charge_id = 7220 then charge.chg_amt else 0 end as Rate
FROM intgX.RENTAL_Tbl FRPleft join intgX.RENTAL_CHG charge on FRP.renalt_document= charge.re