>Given:
>

>Select deposit_no,dep_date from deposits into table sys(2105)
>deposit_ext = alias()
>

>
>How can I reference a field in this table in a join with another table?
>
>deposit_ext.deposit_no does not work as it say deposit_ext is not an object
>
>I have tried other combination of (deposit_ext.deposit_no) etc and evidently not found the right combination.
>
>Any help would be appreciated.

Gaylen,

You can assign table alias in a query.

 SELECT * ;
  FROM  ( DBF(deposit_ext)) dext ;
    JOIN othertable ot ON dext.deposit_no = ot.deposit_no ;
...