[RBASE-L] - RE: 'Undefined Table' error

[Bruce Chitiea]

Huh. That got it.

Would this then be an accurate statement of a general rule:

'Omit the table alias from the left-hand side of of a two-table equality'?

Thanks much, Lena

Bruce

-------- Original Message --------
Subject: [RBASE-L] - RE: 'Undefined Table' error
From: Lena Dammstrom <ldammst...@qmiusa.com>
Date: Wed, June 27, 2012 1:51 pm
To: rbase-l@rbase.com (RBASE-L Mailing List)

Try removing the T1.

UPDATE pksimport SET pksid = t2.pksid

 

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] 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