topic Joining two tables in QlikView https://community.qlik.com/t5/QlikView/Joining-two-tables/m-p/287547#M106960 <HTML><HEAD></HEAD><BODY><P>Check out IntervalMatch in the Ref Guide.</P><P></P><P>-Rob</P></BODY></HTML> Thu, 19 Jan 2012 01:39:55 GMT rwunderlich 2012-01-19T01:39:55Z Joining two tables https://community.qlik.com/t5/QlikView/Joining-two-tables/m-p/287546#M106959 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Any suggestion on this would be appreciated.</P><P></P><P>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.</P><P></P><P>CALL has these fields KEY,Call_Start_Dt,Call_End_dt,Duration</P><P></P><P>AGENT has these fields KEY,Name,Age,Agent_Begin_Dt,Agent_End_Dt</P><P></P><P></P><P>I need to join CALL and AGENT&nbsp; where Call_Start_Dt &gt;=Agent_Begin_Dt and Call_Start_Dt&lt;=Agent_End_Dt</P><P></P><P></P><P></P><P>Can someone let me know what is the best way to achieve this.</P><P></P><P>Thanks......</P></BODY></HTML> Thu, 19 Jan 2012 01:31:33 GMT https://community.qlik.com/t5/QlikView/Joining-two-tables/m-p/287546#M106959 2012-01-19T01:31:33Z Joining two tables https://community.qlik.com/t5/QlikView/Joining-two-tables/m-p/287547#M106960 <HTML><HEAD></HEAD><BODY><P>Check out IntervalMatch in the Ref Guide.</P><P></P><P>-Rob</P></BODY></HTML> Thu, 19 Jan 2012 01:39:55 GMT https://community.qlik.com/t5/QlikView/Joining-two-tables/m-p/287547#M106960 rwunderlich 2012-01-19T01:39:55Z Joining two tables https://community.qlik.com/t5/QlikView/Joining-two-tables/m-p/287548#M106961 <HTML><HEAD></HEAD><BODY><P> Thanks...IntervalMatch worked.</P></BODY></HTML> Thu, 19 Jan 2012 02:40:06 GMT https://community.qlik.com/t5/QlikView/Joining-two-tables/m-p/287548#M106961 2012-01-19T02:40:06Z