>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.
Which database we're talking about here? SQL Server or VFP?
In VFP the syntax is correct, but it would not be Rushmore optimized. Can you do a join by PK (or integer field) instead of a character field?
If the tables are small, then it would not matter much.
If it's not broken, fix it until it is.
My Blog