12 Replies Latest reply: Oct 29, 2018 11:48 AM by Beck Bakytbek RSS

    duplicate values by using of left join

    Beck Bakytbek

      Hi Folks,

       

      i have two table:

       

        

      CategoryProductSales
      C1p110
      C1p150
      C2p220
      C2p312
      C2p341
      C3p215

       

       

        

      CategoryProductCost
      C1p15
      C1p110
      C2p220
      C2p310
      C2p312
      C3p24

       

       

      if i use the left join, than i have a duplicate values, i can solve it by using of concatenation, does anybody have any idea how to solve it by another way?

       

      Thanks a lot

      Beck