Merge fields from two tables in a view based on a span of days
Posted on 2015-01-08
I have two tables; PayData with 5 fields: PRDate, Dept, Amount, Hours, EarnCode and PaySched with 5 fields; PRNum, FromDate, ThroughDate, RptDate, Year.
I want to merge the field values within the PayData file with the correct PRNum when the PayData.PRDate falls within the PaySched.FromDate and PaySched.ThroughDate.
How can I define the view to get what I need?