Re: What's wrong with this clause?

[Bill Downall]

On Wed, 30 May 2001 17:38:54 -0500, Dan Weissmann wrote:

>UPDATE <table1> SET <column1> = <column1> FROM <table1> T1, 
<table2> T2 WHERE T1.Columnx = T2.columnx

Dan,

It's setting the column to itself.  With common column names, you have 
to be more specific.  Try this:

UPDATE table1 SET column1 = t2.column1 +
 FROM table1 T1, table2 T2 +
 WHERE T1.Columnx = T2.columnx

Bill