>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

With MacroSubstitution

&deposit_ext..deposit_no

Tracy