Hi All
Any help for me to resolve this issue will be greatly appreciated.
I have data like this below
My history table data looks like
My current table data is
I need the SQL output that has Add date of 8/1/2020 (SNO : 6). I have RecVal and IND to match and use change_date to start my search from my current table data for the RecVal..
I need to search from the bottom of my history list and get to data that has same RecVal and IND of my current table record and get the minimum add_date based on my change_date.
I dont want history records 1 or 2 based on RecVal and IND