Help Guide For Software Engineer
Wednesday, November 21, 2012
Copy data from one table to another table
You can copy data from one table to another table using following SQL command. This worked fine in informix database.
insert into TableA (field1, field2,field3)
select field1, field2,field3 from TableB where added_on=today