Try:
UPDATE <table1> SET <column1> = t2.column1 FROM <table1> T1, <table2> T2 +
WHERE T1.Columnx = T2.columnx
Good Luck,
Manuel
Dan Weissmann wrote:
> 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
begin:vcard
n:de Aguiar;Manuel
tel;fax:(323)661-7698
tel;work:(323)660-3511
x-mozilla-html:FALSE
url:http://www.mdenterprises.net
org:M|D Enterprises
adr:;;2412 No. Commonwealth Avenue;Los Angeles;California;90027-1206;USA
version:2.1
email;internet:[EMAIL PROTECTED]
title:Developer
note;quoted-printable:The information contained in this e-mail may be privileged, confidential,=0D=0Aand protected from disclosure. If you are not the intended recipient, you=0D=0Aare hereby notified that any dissemination, distribution or duplication of=0D=0Athis communication is strictly prohibited. If you have received this=0D=0Acommunication in error, please notify the sender immediately and delete all=0D=0Acopies.=0D=0A=0D=0Ahttp://www.mdenterprises.net=0D=0Ahttp:/www.databasedeveloper.com=0D=0Ahttp://www.MdrBASE.com=0D=0A
x-mozilla-cpt:;-1
end:vcard
