>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 ;
...
--sb--