I have two files. For simplicity we will call them A and B. Both have some key matching variables. Among the key variables in each file, we have a beginingTime and EndTime. Data layout:

File A: File B: Key1 Key2 BeginingTime Endtime PartNum Key1 Key2 BeginningTime Endtime

Here is the question: I want to the records where all cases match (easy one). I also know that there are cases where key1 and key2 in each file match but the beginingTime in file B as well as the Endtime of B are fully contained in the beginningTime and Endtime of B. In those cases I want to call it a match also.

By fully contained, I have BeginningTimeB <= BeginningA and EndtimeB <= Endtime B.

My final output will be all the data in B and the PartNum in file A.

Any suggestions?