I've got a table (logentries) that has 2 columns of data , analyte1 and analyte3 and I need to swap the data in SOME of the rows. To determine those rows requires a join of the logentries table. So, in order not to have a subqurery select that depended on the logentries table, I created a table (that I will delete after the swap). The temporary table was created by:
CREATE table LogIds3014
INNER JOIN metricsil.productruns
ON (logentries.ProductRunID = productruns.ProductRunID)
INNER JOIN metricsil.products
ON (productruns.ProductID = products.ProductID)
WHERE (products.UnitID =3014);
Ok, no problem, new table is made up with the data I want, so now I go to update my logentries table with the following:
set logentries.Analyte1 = logids3014.Analyte3,
logentries.Analyte3 = logids3014.Analyte1
but instead of working, I get the following error:
Error Code : 1054
Unknown column 'logids3014.LogEntryID' in 'where clause'
(0 ms taken)
I must be doing some bone head mistake, any help would be appreciated.