Kevin thanks for your response. Here are the different errors for each SQl
command I enter.
Command: update tblSNLC,tblSNOrg set
tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblSNLC.Zip;
Error: Failed to execute SQL : SQL update tblSNLC,tblSNOrg set
I think you need a new approach. It appears that update does not support the join you
are attempting.
It seems that you are trying to update
the value for a column from one table with the value of a column from another table.
If this is the case, i would use a shell script to first extract