Joining Tables Using QBE

[pickled]

How do I join these two tables?

tblID = qVar.appendTable( "riv:AvgsDetail.DB" )
tblID = qVar.appendTable( "riv:SumsDetail.DB" )

I can Append and check fields, but can't figure out how to join tables.

Also, can I do calculations on fields using QBE?

 

[footpad]

pickled,

For joining, have you tried using setCriteria() with a value of "_join1"? Calculations would be defined the same way.

Hope this helps...

-- Lance