On Wed, Aug 20, 2003 at 11:16:18 -0400, Jodi Kanter <[EMAIL PROTECTED]> wrote: > Ok. so for now I want to return to where I started. so I renamed the > table and regenerated my original table with the fields in the order > that I like. I cannot just do a > insert into table select * from other_table; > because the fields are in a different order. > Can I do this by listing the fields in my insert in the order in which I > want them placed?
Yes. Instead of using '*' list the columns from the table that currently has the data in the order that they appear in the table that is currently empty. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]