Hello all,I have a question about joining T_CONTRIBUTION and TX_CUST_MEMBERSHIP tables. There is no unique key that identifies the relationship, so we tried to join on customer number and date (converting to smalldatetime cont_dt and create_dt columns), but I would like to know if there is a better way .
Thanks for your help!
Hi Vilius,
You need to reference TX_CUST_MEMB where the cust_memb_no in TX_CUST_MEMBERSHIP is tied to the contribution ref_no.
Cheers,
Kevin
Do you mean TX_CONT_MEMB ? Because I can't find TX_CUST_MEMB table
Apologies for the typo, yes, TX_CONT_MEMB.
Thanks a lot!