2 Replies Latest reply: Nov 28, 2014 1:47 AM by anbu cheliyan RSS

    Innner Join to exclude values in other table

      Hi Experts

       

      I have 2 Tables. One Field in a table contains a lot of data. Therefore, I would like to load only port of the data. Thus, I joined the tables to exclude part of the data:


      Notiz:

      SQL SELECT

      notnr,

      art,

      thema,

      notiz_typ,

      txtnr

      FROM EASY.notiz where notiz_typ = '258';

      Inner Join (Notiz)

      Text:

      SQL SELECT

      txtnr,

      memofeld

      FROM EASY.texte;

       

       

      Problem is, "memofeld" is still loaded completely with 1 Mio datasets. The "Where" condition is ignored in this setting...

       

      Thank you for your help!

       

      Jan