2 Replies Latest reply: Feb 27, 2012 4:46 AM by Evelien Morel RSS

    Left join issue

    Evelien Morel

      Hello,

       

      As this is my first post here, I hope I have given enough information for you to understand the problem.

       

      I'm trying to make a left join between 2 tables, but the left join doesn't appear to be "Left".

       

      Here's the code:

       

      ODBC CONNECT TO AAADTA ();

      BKNF19:

      Load *;

      SQL SELECT *

      FROM XXXXX.AAADTA.BKNF19

      WHERE  

      BJKD19 = 2012 

      AND

      BFKD19  = 'VIT'

      AND

      RKNR19 BETWEEN 600000 AND 799999;

       

      LEFT JOIN (BKNF19)

      LOAD RKNR06, RKNM06;

      SQL SELECT *

      FROM XXXXX.AAADTA.REKF06

      WHERE RSKD06 = 'GRV';

       

      And this is what i get after reload:

      QV AAA cost Left Join.png

      I would expect to see in column RKNR06 only 700200, as that is the number in column RKNR19.

      Instead, I get everything from RKNR06.

       

      What am I doing wrong?

       

      Thanks a lot,

      Evelien