All:
I receive the error message: 'pksid is an undefined table (2059)' when I run the following:
UPDATE pksimport SET t1.pksid = t2.pksid +
FROM pksimport t1, pksurveytest t2 +
WHERE t2.pksdate = t1.pksdate AND +
t2.pkstime = t1.pkstime
Tables 'pksimport' and 'pksurveytest' exist.
Column 'pksid' exists in both tables; holding values in pksurveytest and initially null in pksimport.
??
Bruce
