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