Joining two tables

[#1]

Hi,

Any suggestion on this would be appreciated.

I have 3 tables A,B and C from Oracle.I joined these three tables and create a final memory table in qlikview called CALL.Same way I have two other tables from SQL,joined those two and build a table called AGENT.

CALL has these fields KEY,Call_Start_Dt,Call_End_dt,Duration

AGENT has these fields KEY,Name,Age,Agent_Begin_Dt,Agent_End_Dt

I need to join CALL and AGENT  where Call_Start_Dt >=Agent_Begin_Dt and Call_Start_Dt<=Agent_End_Dt

Can someone let me know what is the best way to achieve this.

Thanks......

[rwunderlich]

Check out IntervalMatch in the Ref Guide.

-Rob

[#3]

Thanks...IntervalMatch worked.