Last post May 03, 2018 07:50 AM by Deepak Panchal
Apr 18, 2018 04:54 PM|kanmai|LINK
I have two tables
the rate field in TABLE2 is set weekly on every Wednesday.
Have to join this table to get the following result, If my table1 action_dt is any day between previous week Wednesday and current week Wednesday, then I have to get previous week rate and set it to the action_dt.
Any help appreciated. Thank you.
May 03, 2018 07:50 AM|Deepak Panchal|LINK
I try to create a dummy tables like yours.
tbl1 inner join tbl2
tbl1.action_dt = tbl2.action_dt