>Craig,
>
>As you can see in the sample code, he *did* assign (sql) aliases. It does not seem unreasonable to assume that SQL would use the self-same alias as has been supplied, when one *has* been supplied.
>
>I know of the Help warning, but I have to doubt that *this* is the reason.
>
>Cheers,
>
>
>Jim N
>
Jim and others,
SQL and relational databases have no concept of record number. When SQL is processing a query you have no guaranttees as to which record is current in which work area. Relatinal systems use the primary key to identify a record and the best solution to this problem is to select the primary key from Cust and forget about the recno.