Try removing the T1. UPDATE pksimport SET pksid = t2.pksid From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Wednesday, June 27, 2012 3:40 PM To: RBASE-L Mailing List Subject: [RBASE-L] - 'Undefined Table' error
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
