6 Replies Latest reply: Nov 6, 2014 11:23 AM by Ashfaq Mohammed RSS

    JOIN doesn't work the way it is supposed to...

    Friedrich Hofmann

      Hi,

       

      I have two tables that I want to join on two fields, [DATE] and [gate]. The issue is

      - In [gate], I have one more distinct value in the first table than I have in the second.

      - I want to keep those

      => LEFT JOIN should be what I need here, shouldn't it?

      <=> I have tried both LEFT and OUTER and in both cases, when I load the created qvd_file into another app, that value is dropped.

      Can somebody tell me what's wrong here?

       

      Thanks a lot!

       

      Best regards,

       

      DataNibbler