Hi,
I have 2 db tables A and B. And I need to have a condition while joining these two tables. i have a field called date in A and date1 and date 2 in B.
The condition i would like to incorporate is A-date should lie between B-date1 and B-date2 (B-date1<A-date<B-date2).
I've tried out Maintenance Views and i can only give a comparative value in the selection conditions (say A-date eq sy-datum).
Can anyone suggest me how to go about this.
Thanks in advance... 😊
Naren