You can list column names in the statement like following as long as you put in same number of columns: insert into table2 (col1, col2, ...) select col3, col4, ... from table1
Forum Rules