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

    Merge Data and then join to another table

      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