6 Replies Latest reply on Jan 9, 2017 2:33 AM by Ahmad Hadzramin Abdul Rahman

    Problem joining tables

    Rachel McGrane

      Can anyone advise. I am looking to join 2 tables (as below) My understanding is that the left join will bring back everything on the left table - Loads by transaction  (which is displayed on the right in the picture below) and only what is in common in the right table - Loads (on the left in the picture)

       

      However even though everything is being brought back back everything in Loads by Tran, which I want, but I only want the one corresponding line in the loads table when I join on date. However as you can see, it is bringing back multiple lines, even though in the source file this line only exists once. can anyone advise?