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.