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