I have one normalized table with many records(+1000000 records) and a smaller
table with characteristics of a filter.   how do i match one list of criteria
with the larger normalized table?  any help would be appreciated....
Marty

Hi friends
I am using VFP6
I have a 2 tables has the following structure:
Ledger ( table 1)

VFP 6 with SP5
Is there a way to do the two quesries in one step? TIA
Select SocNom.SoCode, SocMontants.M_Stack ;
    From SocNom ;

I'm new at this so I beg your indulgence if this is an obvious question.
I'm running on XP, using sql server 2005 and VFP 9.0. I'm using sql pass
through--cannot use a view. I know I can update fields by naming them:
=sqlexec(xx,"update test set wcode=?otest.wcode")