On Thu, Mar 20, 2008 at 7:08 PM, Joe <[EMAIL PROTECTED]> wrote:
> Gurjeet Singh wrote:
> > Except that it doesn't work... Did you try to execute that query; I am
> > assuming not.
> Of course I did,
My bad... I did not run your query either, and based my assumption on my
previous attempt that had thrown an error. Here's something similar to what
had failed in my previous attemt:
update t1 *as e1* set e1.col2 = t1copy.col2, e1.col3 = t1copy.col3
from t1 as t1copy
where e1.col1 = 1 and t1copy.col1 = 3;
As you can see, I had aliased the main table t1, and hence the error.
Best regards,
--
[EMAIL PROTECTED]
[EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad *
18° 32' 57.25"N, 73° 56' 25.42"E - Pune
37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco
http://gurjeet.frihost.net
Mail sent from my BlackLaptop device
