Need help with Where clause to filter on two separate date fields. Both have the same date ranges. Please see the code below.
C.pmt_last_upd_dt between '2013-07-01' and current_date and B.b_a_added_date between '2013-07-01'and current_date
) with data primary index (customer_id, sndr_id, b_a_customer_id, ach_nf_txn_amt_sum, ach_nf_txn_cnt, b_a_added_date, pmt_last_upd_dt, ach_country, trans_amt_usd);
I need to match the dates between the two fields for each record. Do you need to see the complete SQL statement?
You can use the following SQL
C.pmt_last_upd_dt = B.b_a_added_date AND
(C.pmt_last_upd_dt between '2013-07-01' AND current_date
AND B.b_a_added_date between '2013-07-01'AND current_date)
This is what you want? Else please add more description of your scenario.