[RBASE-L] - Variable sum in a report

[Bill Niehaus]

I have a report based upon a table (field) that I want to show a sum
based upon a second table (rawdata).
 
In the past I used a variable to lookup data from the second table.  
vstand2 = Stand2 in RawData WHERE trial = trial AND plotnum = plotnum 
 
 
Is there a way to define a variable to do a sum on a second table, or
do I need to create a view and do a dbcalc on the view?
 
Thanks.
 
Bill