View Single Post
Old 06-14-2005, 12:29 AM  
rickholio
Confirmed User
 
Industry Role:
Join Date: Jan 2004
Location: Nor'easterland
Posts: 1,914
Quote:
Originally Posted by wedouglas
Im just trying to create a fix for a problem im having. is there a quick way to copy data from one table to another?
Code:
insert into TARGET_TABLE 
  select column1, column2, column3, etc from SOURCE_TABLE 
    where some_column=some_criteria;
__________________
~
rickholio is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote