5 Replies Latest reply: Dec 4, 2014 10:17 AM by Peter Rieper RSS

    Multiple entries, load only latest entry

      Hi Experts

       

      I have the following problem:

       

      I load text entries to a textfiled with the following script:

      Notiz:

      SQL SELECT

      notnr,

      art,

      notiz_typ,

      refnr as jobnr,

      txtnr

      FROM EASY.notiz where notiz_typ = '258';

      inner join (Notiz)

      SQL SELECT

      txtnr,

      memofeld

      FROM EASY.texte where txtnr >900000;

       

      memofeld contains my text. Problem is, that each jobnr can contain multiple entires (txtnr). I would only like to show the leteat, with the highest txtnr. Otherwise no entry is displayed in my table until I delete the other entries in the database...

       

      How would I have to script this?

       

      Thank you for your help!