Re: Select into

On Thu, Mar 20, 2008 at 7:08 PM, Joe <<a href="mailto:dev@freedomcircle.net">dev@freedomcircle.net</a>> wrote:<br
/><divclass="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt
0pt0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">Gurjeet Singh wrote:<br /> > Except that it doesn't work...
Didyou try to execute that query; I am<br /> > assuming not.<br /></div>Of course I did, </blockquote></div><br />My
bad...I did not run your query either, and based my assumption on my previous attempt that had thrown an error. Here's
somethingsimilar to what had failed in my previous attemt:<br /><br />update t1  <b>as e1</b> set e1.col2 =
t1copy.col2,e1.col3 = t1copy.col3<br />from t1 as t1copy<br />where e1.col1 = 1 and t1copy.col1 = 3;<br /><br /><br
/>   As you can see, I had aliased the main table t1, and hence the error.<br /><br />Best regards,<br clear="all"
/><br/>-- <br />gurjeet[.singh]@EnterpriseDB.com<br />singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com<br
/><br/>EnterpriseDB <a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br /><br />17° 29' 34.37"N,
78°30' 59.76"E - Hyderabad *<br />18° 32' 57.25"N, 73° 56' 25.42"E - Pune<br />37° 47' 19.72"N, 122° 24' 1.69" W - San
Francisco<br/><br /><a href="http://gurjeet.frihost.net">http://gurjeet.frihost.net</a><br /><br />Mail sent from my
BlackLaptopdevice