Interval Match?

[#1]

Hi,

I have the following two tables:

Tab1:

load * inline
[StartDate, EndDate, EmpPeriod
10000, 20000, FirstYear
20001, 30000, SecondYear
30001, 40000, ThirdYear
];

Tab2:
load * inline
[SDate, EDate, EmpName
15000, 16000, Tony
22000, 29999, Mark
19999, 25000, John
32000, 39000, Ken
10023, 39997, Frank
];

The SDate and EDate would determine the EmpPeriod of EmpName. I tried Interval Match but maybe I am doing something wrong. I can do for either SDate or EDate between StartDate and EndDate, but how do I check if SDate AND EDate are between StartDate and EndDate?

The result should be:

EmpName	EmpPeriod
Tony	FirstYear
Mark	SecondYear
John	FirstYear
John	SecondYear
Ken	ThirdYear
Frank	FirstYear
Frank	SecondYear
Frank	ThirdYear

[#2]

Thank u Sir.

Its perfect

gonna buy a new dictionary to learn some words bigger than Thank you....

was stuck wid this from the last 3 days...

Really happy