5 Replies Latest reply: Jul 1, 2014 1:40 AM by Martin Wosnitza RSS

    Merge Data and then join to another table

    Martin Wosnitza

      Good morning too all,

       

      how can I resolve the following problem:

       

      content Table 1:

      • ID
      • Location
      • etc.

       

      content Table 2:

      • ID
      • freight cost
      • freight cost type

       

      Nearly every ID in Table2 is duplicated because it has two different freight cost types.
      Now I want to have a sum of both and then left join to the table 1. When I just do the left join then I have also the duplications in Table 1, which I dont want to have.


      Who know how to solve this?r

      I appreciate every kind of help!

       

      Thanks and regards

      Martin