Moving Data Without Specifying Column Names In Target - Solved With Thanks

[niche]

I need to move all the data from a source table to target table where the column names from the source match the column names I need to INSERT in the target. I'd use a query like this if I was going to specify column names: "INSERT INTO plan3 (cliorder, stknum) SELECT cliorder, stknum FROM preplan" How could I write this query to say move the source data to the target file when the column names match?

[justsomeguy]

INSERT INTO plan3 SELECT * FROM preplan

[niche]

Thanks justsomeguy.