5 Replies Latest reply: Oct 7, 2011 6:34 AM by Anand Chouhan RSS

    Joining two tables where one field in second table is within the range in two fields in the first table.

      Hi,

       

      Please help, I would like to join this two table:

       

      Table1:

      Entry_DateEntry_No_StartEntry_No_End
      2010-01-011000110010
      2010-01-101001110023

       

      Table2:

      Document_NoEntry_No
      DOC0000110001
      DOC0000210011
      DOC0000310021

       

      Expected Output

      Document_NoEntry_DateEntry_No
      DOC000012010-01-0110001
      DOC000022010-01-0110011
      DOC000032010-01-1010021

       

      Entry_No is within the rainge in two fields in the first table.

       

      Thanks in advance,

       

      Message was edited by: malatiit - Correction on Table 2