Re: Urgent!!!

Posted in 1999

Obnoxio The Clown — Thu, 15 Apr 1999 07:19:45 GMT — source: Informix-list mailing list archive (1991-1998)

>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; INSERT INTO your_loading_table_name_here SELECT column_list FROM your_source_table_name_here HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com