>>Do not rely on functions like recno() and deleted() when there are more than one table in the query.
>
>What about RECNO("kartei") or when a specific alias is specified. Does it work then?
>
>

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
>

No, as I said, never rely on recno() when it is not a single table in SQL. In one or more cases it might seem to work right, but I remember cases where it wouldn't. I just can't think of a good demo code right now.