SELECT kartei.* , RECNO("kartei") as satznr, kunden.vorname, ; ^^^^^^^^^^^^^^^ kunden.name1, kunden.name2, kunden.name3, kunden.strasse, ; kunden.plz, kunden.ort ; FROM kartei ; INNER JOIN kunden ON kartei.kundennr == kunden.kundennr ; WHERE kartei.vormerker ; AND kartei.nummer == this.cIsbn ; AND NOT DELETED() ; ORDER BY best_dat DESC ; INTO CURSOR myvormerker READWRITE