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.