It's almost right. You don't need ALLTRIM though,and only need LOWER()/UPPER() only if the case of the data is different.
UPDATE Table2 SET Column2 = TRIM(Table1.Column1) + TRIM(Table1.Column3) ;
FROM Table2 ;
INNER JOIN Table1 ON Table2.Column1 == Table1.Column2
THre're no stupid questions, only stupid answers. :)
>I know this isn't right:
>
>UPDATE Table2 SET Column2 = TRIM(Table1.Column1) + TRIM(Table1.Column3) FROM Table2 INNER JOIN Table1 ON Lower(Alltrim(Table2.Column1)) == Lower(Alltrim(Table1.Column2))
>
>What is right?
>
>I know I sound like an idiot, I am pretty new to this stuff.
--sb--