9 Replies Latest reply: Nov 27, 2014 11:51 PM by Amol Khochare RSS

    Join & exclude

      Hi Experts

       

      I have 2 Tables. One Field 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:

       

      Text:

       

      SQL SELECT

      txtnr,

      memofeld

      FROM EASY.texte;

       

      Notiz:

       

      left Join (Text)

       

      SQL SELECT

        notnr,

      art,

      thema,

      notiz_typ,

      txtnr

      FROM EASY.notiz where notiz_typ is = 258;

       

      Problem is, "memofeld" is still loaded completely with 1 Mio datasets. I would only like to load entries where notiz_typ is = 258.

       

      Anybody know a solution?

       

      Thank you for your help!

       

      Jan