Sergey - thanks again. I used tracy's suggestion, however thanks for the heads up on the join. I plan on using it the next time when I create some new joins.
Gaylen
>>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 ;
>...
>