7 Replies Latest reply: Sep 10, 2014 5:21 PM by Stefan Kunte RSS

    Match tables from 2 sources

      Hi guys,

      can you tell me, how can I match tables from 2 sources ?

      like:

       

      T1: No,

           Name,

           FName,

           Amount,

           BDay

      SQL ** FROM X;

       

      T2: No,

           Name,

           FName,

           Amount,

           BDay

      SQL ** FROM Y;

       

      The difficult is to have disdtinct values because of the amount..

       

      If I Join the via the No (Key), it +1 every values (controll with count(tablename))

       

      I need both sources, because from source 1 are data from periode 1-2; and source 2 from periode 3-4;

      but some data like no, name, ... are double (from s1 ans s2..)

       

      hope you can help me

       

      best regards

       

      TM