Selecting Feilds from 2 Resident Tables

[#1]

Hi all,

Is there a way that you can select certain feilds from 2 tables already loaded as a sub table, essentially using a join in a resident statement.

[Anonymous]

Yes, you can :).

[#3]

10 points...now can you show me some code... ....please

[Anonymous]

product_sales:
load
 product,
 group,
 listprice
resident prod;
left join
load
 product,
 quantity
resident sales

If you want in the same time to do listprice* cantity you have to load the table product_sale again ad do the calculations.

[#5]

thanks...