13 Replies Latest reply: Sep 29, 2011 11:36 AM by Anand Chouhan RSS

    Concatenating two tables

    sandeepa rout

      Hi All,

       

      Table1:

       

       

      InvooiceNoCustCodeProdCode
      110100
      220200
      330300
      440400

       

       

      Table2:

       

       

      InvoiceNoCustCodeProdCode
      110100
      220200
      990300
      880400
      550500
      660600
      770700

       

       

      Table3:

       

      InvoiceNo
      Table1.CustCode
      Table2.CustCode
      11010
      22020
      330-
      440-
      5
      50
      6
      60
      7
      70
      8
      80
      9
      90

       

      how to achieve Table3 from table 1 and table2?

       

      Thanks.