1 Reply Latest reply: May 6, 2014 5:54 AM by Ashfaq Mohammed RSS

    Loading a table if customer exists in another table

    Håkan Fogelin

      Hello,

       

      how do I only load data into table Invoice for customers that exists in table Customer_Read.

      The field cunumber exists in both tables. The code below gives an empty table Invoice:

       

      Customer_Read:

      Load

      @1 as cunumber,

      @2 as name

      from customer.txt;

       

      Invoice:

      Load

      @1 as cunumber;

      .

      .

      from invoice.txt where exists(Customer_Read,cunumber);

       

      kindly

      Håkan