Re: Urgent!!!

Posted in 1999

Gabor Heppes — Wed, 14 Apr 1999 23:32:55 GMT — source: Informix-list mailing list archive (1991-1998)

In article <7f36ko$4st$1@nnrp1.dejanews.com>, l_nadella@yahoo.com wrote: > Hello all, I am familiar to Oracle but new to Informix. Could anyone please > tell me how to populate a table by selecting a result set from another table. > In Oracle I can do Insert into table tablename as select col1, col2, col3 > from tablename2; > > TIA > Lak Nadella > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own > Just leave out the "as" keyword and it should work fine! -- Gabor Heppes IBM Global Services gaborh@au1.ibm.com -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own