Dan,
You almost have it:
UPDATE <table1> SET <column1> = t2.<columnA> FROM <table1> T1, <table2> T2
WHERE T1.Columnx = T2.columnx
Troy
>===== Original Message From [EMAIL PROTECTED] =====
>Hi all.
>
>I'm trying to update a column in table one with the values in table 2. Seems
>simple, but nothing is being updated. What am I missing?
>
>UPDATE <table1> SET <column1> = <column1> FROM <table1> T1, <table2> T2
>WHERE T1.Columnx = T2.columnx
>
>There are values in <table2.column1.> but no values in <table1.column1>.
>After the UPDATE is run, there are still no values in <table1.column1>
>
>Thanks,
>
>Dan
Troy Sosamon
Denver Co
[EMAIL PROTECTED]
