Join tables that a between a variable value
Please help a moderate user. I can do basic joins with little problem- but having trouble with this twist. FP 11 Pro on Mac.
Need to join two tables (say A and B).
Table A has a ID, Beginning Date, Ending Date (like 444, 07012011, 07302011)
Table B also has an ID, and a service date (like 444, 07152011).
I need to join records IF
ID = ID (not a problem)
IF service date in B falls between beginning date and ending date in A.
It is this second one that gets me. I have only done = joins, never a "falls between" join.