Hi Suzanne,
When you say:
insert into table_2 select * from table_1
alls fine. All the records and fields will get
copied.
But when you say:
insert into table_2 select fieldname_1 from table_1
you are just selecting fieldname_1 from table_1
while
table_2 consists of fieldname_2 als
I have 2 tables with identical structures. The following sql statement works
fine:
insert into table_2 select * from table_1
but if I attempt to say
insert into table_2 select fieldname_1 from table_1
or any combination of selecting specific fields to be put into the other
table, I get an
