Dan,
You'll need to specify the table in the right side of the equal sign.
UPDATE <table1> SET <column1> = <T2.column1> FROM <table1> T1, <table2> T2
WHERE T1.Columnx = T2.columnx
Assuming you want the value of T2.Column1 to be placed in T1.Column1 where
T1.Columnx = T2.Columnx
Rommel
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Dan Weissmann
Sent: Wednesday, May 30, 2001 3:39 PM
To: RBase List Server
Subject: What's wrong with this clause?
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
